* box-steffensmeier et al  
* february 2025
* recoding data  

*** Load data *** 
clear 
use "data_nom_original_jop2025.dta"
* is really just the --- NEWData_Feb2023_NODuplicates.dta --- but before the new committee variables... 
* use "data_raw_nominations_jop2025.dta"
* i think some stuff got added to "data_all_vars_apr2023.dta"   


*** code int group variables *** 
egen nonmiss_both_SO = rownonmiss( /// 
	interestgroup1_C_SO interestgroup2_C_SO interestgroup3_C_SO interestgroup4_C_SO interestgroup5_C_SO interestgroup6_C_SO interestgroup7_C_SO interestgroup8_C_SO interestgroup9_C_SO interestgroup10_C_SO interestgroup11_C_SO interestgroup12_C_SO interestgroup13_C_SO interestgroup14_C_SO interestgroup15_C_SO interestgroup16_C_SO interestgroup17_C_SO interestgroup18_C_SO interestgroup19_C_SO interestgroup20_C_SO interestgroup21_C_SO interestgroup22_C_SO interestgroup23_C_SO interestgroup24_C_SO interestgroup25_C_SO interestgroup26_C_SO interestgroup27_C_SO interestgroup28_C_SO interestgroup29_C_SO interestgroup30_C_SO interestgroup31_C_SO interestgroup32_C_SO interestgroup33_C_SO interestgroup34_C_SO interestgroup35_C_SO interestgroup36_C_SO interestgroup37_C_SO interestgroup38_C_SO interestgroup39_C_SO interestgroup40_C_SO interestgroup41_C_SO interestgroup42_C_SO interestgroup43_C_SO interestgroup44_C_SO interestgroup45_C_SO interestgroup46_C_SO interestgroup47_C_SO interestgroup48_C_SO interestgroup49_C_SO interestgroup50_C_SO interestgroup51_C_SO interestgroup52_C_SO interestgroup53_C_SO interestgroup54_C_SO interestgroup55_C_SO interestgroup56_C_SO interestgroup57_C_SO interestgroup58_C_SO interestgroup59_C_SO interestgroup60_C_SO interestgroup61_C_SO interestgroup62_C_SO interestgroup63_C_SO interestgroup64_C_SO interestgroup65_C_SO interestgroup66_C_SO interestgroup67_C_SO interestgroup68_C_SO interestgroup69_C_SO interestgroup70_C_SO interestgroup71_C_SO interestgroup72_C_SO interestgroup73_C_SO interestgroup74_C_SO interestgroup75_C_SO interestgroup76_C_SO interestgroup77_C_SO interestgroup78_C_SO interestgroup79_C_SO interestgroup80_C_SO interestgroup81_C_SO interestgroup82_C_SO interestgroup83_C_SO interestgroup84_C_SO interestgroup85_C_SO interestgroup86_C_SO interestgroup87_C_SO interestgroup88_C_SO interestgroup89_C_SO interestgroup90_C_SO interestgroup91_C_SO interestgroup92_C_SO interestgroup93_C_SO interestgroup94_C_SO interestgroup95_C_SO interestgroup96_C_SO interestgroup97_C_SO interestgroup98_C_SO interestgroup99_C_SO interestgroup100_C_SO interestgroup101_C_SO interestgroup102_C_SO interestgroup103_C_SO interestgroup104_C_SO interestgroup105_C_SO interestgroup106_C_SO interestgroup107_C_SO interestgroup108_C_SO interestgroup109_C_SO interestgroup110_C_SO interestgroup111_C_SO interestgroup112_C_SO interestgroup113_C_SO interestgroup114_C_SO interestgroup115_C_SO interestgroup116_C_SO interestgroup117_C_SO interestgroup118_C_SO interestgroup119_C_SO interestgroup120_C_SO interestgroup121_C_SO interestgroup122_C_SO interestgroup123_C_SO interestgroup124_C_SO interestgroup125_C_SO interestgroup126_C_SO interestgroup127_C_SO interestgroup128_C_SO interestgroup129_C_SO interestgroup130_C_SO interestgroup131_C_SO interestgroup132_C_SO interestgroup133_C_SO interestgroup134_C_SO interestgroup135_C_SO interestgroup136_C_SO interestgroup137_C_SO interestgroup138_C_SO interestgroup139_C_SO interestgroup140_C_SO interestgroup141_C_SO interestgroup142_C_SO interestgroup143_C_SO interestgroup144_C_SO interestgroup145_C_SO interestgroup146_C_SO interestgroup147_C_SO interestgroup148_C_SO interestgroup149_C_SO interestgroup150_C_SO interestgroup151_C_SO interestgroup152_C_SO interestgroup153_C_SO interestgroup154_C_SO interestgroup155_C_SO interestgroup156_C_SO interestgroup157_C_SO interestgroup158_C_SO interestgroup159_C_SO interestgroup160_C_SO interestgroup161_C_SO interestgroup162_C_SO interestgroup163_C_SO interestgroup164_C_SO interestgroup165_C_SO interestgroup166_C_SO interestgroup167_C_SO interestgroup168_C_SO interestgroup169_C_SO interestgroup170_C_SO interestgroup171_C_SO interestgroup172_C_SO interestgroup173_C_SO interestgroup174_C_SO interestgroup175_C_SO interestgroup176_C_SO interestgroup177_C_SO interestgroup178_C_SO interestgroup179_C_SO interestgroup180_C_SO	///
	interestgroup1_LN_SO interestgroup2_LN_SO interestgroup3_LN_SO interestgroup4_LN_SO interestgroup5_LN_SO interestgroup6_LN_SO interestgroup7_LN_SO interestgroup8_LN_SO interestgroup9_LN_SO interestgroup10_LN_SO interestgroup11_LN_SO interestgroup12_LN_SO interestgroup13_LN_SO interestgroup14_LN_SO interestgroup15_LN_SO interestgroup16_LN_SO interestgroup17_LN_SO interestgroup18_LN_SO interestgroup19_LN_SO interestgroup20_LN_SO interestgroup21_LN_SO interestgroup22_LN_SO interestgroup23_LN_SO interestgroup24_LN_SO interestgroup25_LN_SO interestgroup26_LN_SO interestgroup27_LN_SO interestgroup28_LN_SO interestgroup29_LN_SO interestgroup30_LN_SO interestgroup31_LN_SO interestgroup32_LN_SO interestgroup33_LN_SO interestgroup34_LN_SO interestgroup35_LN_SO interestgroup36_LN_SO interestgroup37_LN_SO interestgroup38_LN_SO interestgroup39_LN_SO interestgroup40_LN_SO interestgroup41_LN_SO interestgroup42_LN_SO interestgroup43_LN_SO interestgroup44_LN_SO interestgroup45_LN_SO interestgroup46_LN_SO interestgroup47_LN_SO interestgroup48_LN_SO interestgroup49_LN_SO interestgroup50_LN_SO interestgroup51_LN_SO interestgroup52_LN_SO interestgroup53_LN_SO interestgroup54_LN_SO interestgroup55_LN_SO interestgroup56_LN_SO interestgroup57_LN_SO interestgroup58_LN_SO interestgroup59_LN_SO interestgroup60_LN_SO interestgroup61_LN_SO interestgroup62_LN_SO interestgroup63_LN_SO interestgroup64_LN_SO interestgroup65_LN_SO interestgroup66_LN_SO interestgroup67_LN_SO interestgroup68_LN_SO interestgroup69_LN_SO interestgroup70_LN_SO interestgroup71_LN_SO interestgroup72_LN_SO interestgroup73_LN_SO interestgroup74_LN_SO interestgroup75_LN_SO interestgroup76_LN_SO interestgroup77_LN_SO interestgroup78_LN_SO interestgroup79_LN_SO interestgroup80_LN_SO interestgroup81_LN_SO interestgroup82_LN_SO interestgroup83_LN_SO interestgroup84_LN_SO interestgroup85_LN_SO interestgroup86_LN_SO interestgroup87_LN_SO interestgroup88_LN_SO interestgroup89_LN_SO interestgroup90_LN_SO interestgroup91_LN_SO interestgroup92_LN_SO interestgroup93_LN_SO interestgroup94_LN_SO interestgroup95_LN_SO interestgroup96_LN_SO interestgroup97_LN_SO interestgroup98_LN_SO interestgroup99_LN_SO interestgroup100_LN_SO interestgroup101_LN_SO interestgroup102_LN_SO interestgroup103_LN_SO interestgroup104_LN_SO interestgroup105_LN_SO interestgroup106_LN_SO interestgroup107_LN_SO interestgroup108_LN_SO interestgroup109_LN_SO interestgroup110_LN_SO interestgroup111_LN_SO interestgroup112_LN_SO interestgroup113_LN_SO interestgroup114_LN_SO interestgroup115_LN_SO interestgroup116_LN_SO interestgroup117_LN_SO interestgroup118_LN_SO interestgroup119_LN_SO interestgroup120_LN_SO interestgroup121_LN_SO interestgroup122_LN_SO interestgroup123_LN_SO interestgroup124_LN_SO interestgroup125_LN_SO interestgroup126_LN_SO interestgroup127_LN_SO interestgroup128_LN_SO interestgroup129_LN_SO interestgroup130_LN_SO interestgroup131_LN_SO ///
		)
label var nonmiss_both_SO "nominees w ig in supp or opp"

egen nonmiss_supp_SO = anycount( /// 
	interestgroup1_C_SO interestgroup2_C_SO interestgroup3_C_SO interestgroup4_C_SO interestgroup5_C_SO interestgroup6_C_SO interestgroup7_C_SO interestgroup8_C_SO interestgroup9_C_SO interestgroup10_C_SO interestgroup11_C_SO interestgroup12_C_SO interestgroup13_C_SO interestgroup14_C_SO interestgroup15_C_SO interestgroup16_C_SO interestgroup17_C_SO interestgroup18_C_SO interestgroup19_C_SO interestgroup20_C_SO interestgroup21_C_SO interestgroup22_C_SO interestgroup23_C_SO interestgroup24_C_SO interestgroup25_C_SO interestgroup26_C_SO interestgroup27_C_SO interestgroup28_C_SO interestgroup29_C_SO interestgroup30_C_SO interestgroup31_C_SO interestgroup32_C_SO interestgroup33_C_SO interestgroup34_C_SO interestgroup35_C_SO interestgroup36_C_SO interestgroup37_C_SO interestgroup38_C_SO interestgroup39_C_SO interestgroup40_C_SO interestgroup41_C_SO interestgroup42_C_SO interestgroup43_C_SO interestgroup44_C_SO interestgroup45_C_SO interestgroup46_C_SO interestgroup47_C_SO interestgroup48_C_SO interestgroup49_C_SO interestgroup50_C_SO interestgroup51_C_SO interestgroup52_C_SO interestgroup53_C_SO interestgroup54_C_SO interestgroup55_C_SO interestgroup56_C_SO interestgroup57_C_SO interestgroup58_C_SO interestgroup59_C_SO interestgroup60_C_SO interestgroup61_C_SO interestgroup62_C_SO interestgroup63_C_SO interestgroup64_C_SO interestgroup65_C_SO interestgroup66_C_SO interestgroup67_C_SO interestgroup68_C_SO interestgroup69_C_SO interestgroup70_C_SO interestgroup71_C_SO interestgroup72_C_SO interestgroup73_C_SO interestgroup74_C_SO interestgroup75_C_SO interestgroup76_C_SO interestgroup77_C_SO interestgroup78_C_SO interestgroup79_C_SO interestgroup80_C_SO interestgroup81_C_SO interestgroup82_C_SO interestgroup83_C_SO interestgroup84_C_SO interestgroup85_C_SO interestgroup86_C_SO interestgroup87_C_SO interestgroup88_C_SO interestgroup89_C_SO interestgroup90_C_SO interestgroup91_C_SO interestgroup92_C_SO interestgroup93_C_SO interestgroup94_C_SO interestgroup95_C_SO interestgroup96_C_SO interestgroup97_C_SO interestgroup98_C_SO interestgroup99_C_SO interestgroup100_C_SO interestgroup101_C_SO interestgroup102_C_SO interestgroup103_C_SO interestgroup104_C_SO interestgroup105_C_SO interestgroup106_C_SO interestgroup107_C_SO interestgroup108_C_SO interestgroup109_C_SO interestgroup110_C_SO interestgroup111_C_SO interestgroup112_C_SO interestgroup113_C_SO interestgroup114_C_SO interestgroup115_C_SO interestgroup116_C_SO interestgroup117_C_SO interestgroup118_C_SO interestgroup119_C_SO interestgroup120_C_SO interestgroup121_C_SO interestgroup122_C_SO interestgroup123_C_SO interestgroup124_C_SO interestgroup125_C_SO interestgroup126_C_SO interestgroup127_C_SO interestgroup128_C_SO interestgroup129_C_SO interestgroup130_C_SO interestgroup131_C_SO interestgroup132_C_SO interestgroup133_C_SO interestgroup134_C_SO interestgroup135_C_SO interestgroup136_C_SO interestgroup137_C_SO interestgroup138_C_SO interestgroup139_C_SO interestgroup140_C_SO interestgroup141_C_SO interestgroup142_C_SO interestgroup143_C_SO interestgroup144_C_SO interestgroup145_C_SO interestgroup146_C_SO interestgroup147_C_SO interestgroup148_C_SO interestgroup149_C_SO interestgroup150_C_SO interestgroup151_C_SO interestgroup152_C_SO interestgroup153_C_SO interestgroup154_C_SO interestgroup155_C_SO interestgroup156_C_SO interestgroup157_C_SO interestgroup158_C_SO interestgroup159_C_SO interestgroup160_C_SO interestgroup161_C_SO interestgroup162_C_SO interestgroup163_C_SO interestgroup164_C_SO interestgroup165_C_SO interestgroup166_C_SO interestgroup167_C_SO interestgroup168_C_SO interestgroup169_C_SO interestgroup170_C_SO interestgroup171_C_SO interestgroup172_C_SO interestgroup173_C_SO interestgroup174_C_SO interestgroup175_C_SO interestgroup176_C_SO interestgroup177_C_SO interestgroup178_C_SO interestgroup179_C_SO interestgroup180_C_SO	/// 	
    interestgroup1_LN_SO interestgroup2_LN_SO interestgroup3_LN_SO interestgroup4_LN_SO interestgroup5_LN_SO interestgroup6_LN_SO interestgroup7_LN_SO interestgroup8_LN_SO interestgroup9_LN_SO interestgroup10_LN_SO interestgroup11_LN_SO interestgroup12_LN_SO interestgroup13_LN_SO interestgroup14_LN_SO interestgroup15_LN_SO interestgroup16_LN_SO interestgroup17_LN_SO interestgroup18_LN_SO interestgroup19_LN_SO interestgroup20_LN_SO interestgroup21_LN_SO interestgroup22_LN_SO interestgroup23_LN_SO interestgroup24_LN_SO interestgroup25_LN_SO interestgroup26_LN_SO interestgroup27_LN_SO interestgroup28_LN_SO interestgroup29_LN_SO interestgroup30_LN_SO interestgroup31_LN_SO interestgroup32_LN_SO interestgroup33_LN_SO interestgroup34_LN_SO interestgroup35_LN_SO interestgroup36_LN_SO interestgroup37_LN_SO interestgroup38_LN_SO interestgroup39_LN_SO interestgroup40_LN_SO interestgroup41_LN_SO interestgroup42_LN_SO interestgroup43_LN_SO interestgroup44_LN_SO interestgroup45_LN_SO interestgroup46_LN_SO interestgroup47_LN_SO interestgroup48_LN_SO interestgroup49_LN_SO interestgroup50_LN_SO interestgroup51_LN_SO interestgroup52_LN_SO interestgroup53_LN_SO interestgroup54_LN_SO interestgroup55_LN_SO interestgroup56_LN_SO interestgroup57_LN_SO interestgroup58_LN_SO interestgroup59_LN_SO interestgroup60_LN_SO interestgroup61_LN_SO interestgroup62_LN_SO interestgroup63_LN_SO interestgroup64_LN_SO interestgroup65_LN_SO interestgroup66_LN_SO interestgroup67_LN_SO interestgroup68_LN_SO interestgroup69_LN_SO interestgroup70_LN_SO interestgroup71_LN_SO interestgroup72_LN_SO interestgroup73_LN_SO interestgroup74_LN_SO interestgroup75_LN_SO interestgroup76_LN_SO interestgroup77_LN_SO interestgroup78_LN_SO interestgroup79_LN_SO interestgroup80_LN_SO interestgroup81_LN_SO interestgroup82_LN_SO interestgroup83_LN_SO interestgroup84_LN_SO interestgroup85_LN_SO interestgroup86_LN_SO interestgroup87_LN_SO interestgroup88_LN_SO interestgroup89_LN_SO interestgroup90_LN_SO interestgroup91_LN_SO interestgroup92_LN_SO interestgroup93_LN_SO interestgroup94_LN_SO interestgroup95_LN_SO interestgroup96_LN_SO interestgroup97_LN_SO interestgroup98_LN_SO interestgroup99_LN_SO interestgroup100_LN_SO interestgroup101_LN_SO interestgroup102_LN_SO interestgroup103_LN_SO interestgroup104_LN_SO interestgroup105_LN_SO interestgroup106_LN_SO interestgroup107_LN_SO interestgroup108_LN_SO interestgroup109_LN_SO interestgroup110_LN_SO interestgroup111_LN_SO interestgroup112_LN_SO interestgroup113_LN_SO interestgroup114_LN_SO interestgroup115_LN_SO interestgroup116_LN_SO interestgroup117_LN_SO interestgroup118_LN_SO interestgroup119_LN_SO interestgroup120_LN_SO interestgroup121_LN_SO interestgroup122_LN_SO interestgroup123_LN_SO interestgroup124_LN_SO interestgroup125_LN_SO interestgroup126_LN_SO interestgroup127_LN_SO interestgroup128_LN_SO interestgroup129_LN_SO interestgroup130_LN_SO interestgroup131_LN_SO) ///
    , values(1)
	
egen nonmiss_opp_SO = anycount( /// 
	interestgroup1_C_SO interestgroup2_C_SO interestgroup3_C_SO interestgroup4_C_SO interestgroup5_C_SO interestgroup6_C_SO interestgroup7_C_SO interestgroup8_C_SO interestgroup9_C_SO interestgroup10_C_SO interestgroup11_C_SO interestgroup12_C_SO interestgroup13_C_SO interestgroup14_C_SO interestgroup15_C_SO interestgroup16_C_SO interestgroup17_C_SO interestgroup18_C_SO interestgroup19_C_SO interestgroup20_C_SO interestgroup21_C_SO interestgroup22_C_SO interestgroup23_C_SO interestgroup24_C_SO interestgroup25_C_SO interestgroup26_C_SO interestgroup27_C_SO interestgroup28_C_SO interestgroup29_C_SO interestgroup30_C_SO interestgroup31_C_SO interestgroup32_C_SO interestgroup33_C_SO interestgroup34_C_SO interestgroup35_C_SO interestgroup36_C_SO interestgroup37_C_SO interestgroup38_C_SO interestgroup39_C_SO interestgroup40_C_SO interestgroup41_C_SO interestgroup42_C_SO interestgroup43_C_SO interestgroup44_C_SO interestgroup45_C_SO interestgroup46_C_SO interestgroup47_C_SO interestgroup48_C_SO interestgroup49_C_SO interestgroup50_C_SO interestgroup51_C_SO interestgroup52_C_SO interestgroup53_C_SO interestgroup54_C_SO interestgroup55_C_SO interestgroup56_C_SO interestgroup57_C_SO interestgroup58_C_SO interestgroup59_C_SO interestgroup60_C_SO interestgroup61_C_SO interestgroup62_C_SO interestgroup63_C_SO interestgroup64_C_SO interestgroup65_C_SO interestgroup66_C_SO interestgroup67_C_SO interestgroup68_C_SO interestgroup69_C_SO interestgroup70_C_SO interestgroup71_C_SO interestgroup72_C_SO interestgroup73_C_SO interestgroup74_C_SO interestgroup75_C_SO interestgroup76_C_SO interestgroup77_C_SO interestgroup78_C_SO interestgroup79_C_SO interestgroup80_C_SO interestgroup81_C_SO interestgroup82_C_SO interestgroup83_C_SO interestgroup84_C_SO interestgroup85_C_SO interestgroup86_C_SO interestgroup87_C_SO interestgroup88_C_SO interestgroup89_C_SO interestgroup90_C_SO interestgroup91_C_SO interestgroup92_C_SO interestgroup93_C_SO interestgroup94_C_SO interestgroup95_C_SO interestgroup96_C_SO interestgroup97_C_SO interestgroup98_C_SO interestgroup99_C_SO interestgroup100_C_SO interestgroup101_C_SO interestgroup102_C_SO interestgroup103_C_SO interestgroup104_C_SO interestgroup105_C_SO interestgroup106_C_SO interestgroup107_C_SO interestgroup108_C_SO interestgroup109_C_SO interestgroup110_C_SO interestgroup111_C_SO interestgroup112_C_SO interestgroup113_C_SO interestgroup114_C_SO interestgroup115_C_SO interestgroup116_C_SO interestgroup117_C_SO interestgroup118_C_SO interestgroup119_C_SO interestgroup120_C_SO interestgroup121_C_SO interestgroup122_C_SO interestgroup123_C_SO interestgroup124_C_SO interestgroup125_C_SO interestgroup126_C_SO interestgroup127_C_SO interestgroup128_C_SO interestgroup129_C_SO interestgroup130_C_SO interestgroup131_C_SO interestgroup132_C_SO interestgroup133_C_SO interestgroup134_C_SO interestgroup135_C_SO interestgroup136_C_SO interestgroup137_C_SO interestgroup138_C_SO interestgroup139_C_SO interestgroup140_C_SO interestgroup141_C_SO interestgroup142_C_SO interestgroup143_C_SO interestgroup144_C_SO interestgroup145_C_SO interestgroup146_C_SO interestgroup147_C_SO interestgroup148_C_SO interestgroup149_C_SO interestgroup150_C_SO interestgroup151_C_SO interestgroup152_C_SO interestgroup153_C_SO interestgroup154_C_SO interestgroup155_C_SO interestgroup156_C_SO interestgroup157_C_SO interestgroup158_C_SO interestgroup159_C_SO interestgroup160_C_SO interestgroup161_C_SO interestgroup162_C_SO interestgroup163_C_SO interestgroup164_C_SO interestgroup165_C_SO interestgroup166_C_SO interestgroup167_C_SO interestgroup168_C_SO interestgroup169_C_SO interestgroup170_C_SO interestgroup171_C_SO interestgroup172_C_SO interestgroup173_C_SO interestgroup174_C_SO interestgroup175_C_SO interestgroup176_C_SO interestgroup177_C_SO interestgroup178_C_SO interestgroup179_C_SO interestgroup180_C_SO	/// 	
    interestgroup1_LN_SO interestgroup2_LN_SO interestgroup3_LN_SO interestgroup4_LN_SO interestgroup5_LN_SO interestgroup6_LN_SO interestgroup7_LN_SO interestgroup8_LN_SO interestgroup9_LN_SO interestgroup10_LN_SO interestgroup11_LN_SO interestgroup12_LN_SO interestgroup13_LN_SO interestgroup14_LN_SO interestgroup15_LN_SO interestgroup16_LN_SO interestgroup17_LN_SO interestgroup18_LN_SO interestgroup19_LN_SO interestgroup20_LN_SO interestgroup21_LN_SO interestgroup22_LN_SO interestgroup23_LN_SO interestgroup24_LN_SO interestgroup25_LN_SO interestgroup26_LN_SO interestgroup27_LN_SO interestgroup28_LN_SO interestgroup29_LN_SO interestgroup30_LN_SO interestgroup31_LN_SO interestgroup32_LN_SO interestgroup33_LN_SO interestgroup34_LN_SO interestgroup35_LN_SO interestgroup36_LN_SO interestgroup37_LN_SO interestgroup38_LN_SO interestgroup39_LN_SO interestgroup40_LN_SO interestgroup41_LN_SO interestgroup42_LN_SO interestgroup43_LN_SO interestgroup44_LN_SO interestgroup45_LN_SO interestgroup46_LN_SO interestgroup47_LN_SO interestgroup48_LN_SO interestgroup49_LN_SO interestgroup50_LN_SO interestgroup51_LN_SO interestgroup52_LN_SO interestgroup53_LN_SO interestgroup54_LN_SO interestgroup55_LN_SO interestgroup56_LN_SO interestgroup57_LN_SO interestgroup58_LN_SO interestgroup59_LN_SO interestgroup60_LN_SO interestgroup61_LN_SO interestgroup62_LN_SO interestgroup63_LN_SO interestgroup64_LN_SO interestgroup65_LN_SO interestgroup66_LN_SO interestgroup67_LN_SO interestgroup68_LN_SO interestgroup69_LN_SO interestgroup70_LN_SO interestgroup71_LN_SO interestgroup72_LN_SO interestgroup73_LN_SO interestgroup74_LN_SO interestgroup75_LN_SO interestgroup76_LN_SO interestgroup77_LN_SO interestgroup78_LN_SO interestgroup79_LN_SO interestgroup80_LN_SO interestgroup81_LN_SO interestgroup82_LN_SO interestgroup83_LN_SO interestgroup84_LN_SO interestgroup85_LN_SO interestgroup86_LN_SO interestgroup87_LN_SO interestgroup88_LN_SO interestgroup89_LN_SO interestgroup90_LN_SO interestgroup91_LN_SO interestgroup92_LN_SO interestgroup93_LN_SO interestgroup94_LN_SO interestgroup95_LN_SO interestgroup96_LN_SO interestgroup97_LN_SO interestgroup98_LN_SO interestgroup99_LN_SO interestgroup100_LN_SO interestgroup101_LN_SO interestgroup102_LN_SO interestgroup103_LN_SO interestgroup104_LN_SO interestgroup105_LN_SO interestgroup106_LN_SO interestgroup107_LN_SO interestgroup108_LN_SO interestgroup109_LN_SO interestgroup110_LN_SO interestgroup111_LN_SO interestgroup112_LN_SO interestgroup113_LN_SO interestgroup114_LN_SO interestgroup115_LN_SO interestgroup116_LN_SO interestgroup117_LN_SO interestgroup118_LN_SO interestgroup119_LN_SO interestgroup120_LN_SO interestgroup121_LN_SO interestgroup122_LN_SO interestgroup123_LN_SO interestgroup124_LN_SO interestgroup125_LN_SO interestgroup126_LN_SO interestgroup127_LN_SO interestgroup128_LN_SO interestgroup129_LN_SO interestgroup130_LN_SO interestgroup131_LN_SO) ///
    , values(0)	
 	
label var nonmiss_supp_SO "nominees w ig in support"	
label var nonmiss_opp_SO "nominees w ig in opp"	

egen nonmiss_supp_C_SO = anycount( /// 
	interestgroup1_C_SO interestgroup2_C_SO interestgroup3_C_SO interestgroup4_C_SO interestgroup5_C_SO interestgroup6_C_SO interestgroup7_C_SO interestgroup8_C_SO interestgroup9_C_SO interestgroup10_C_SO interestgroup11_C_SO interestgroup12_C_SO interestgroup13_C_SO interestgroup14_C_SO interestgroup15_C_SO interestgroup16_C_SO interestgroup17_C_SO interestgroup18_C_SO interestgroup19_C_SO interestgroup20_C_SO interestgroup21_C_SO interestgroup22_C_SO interestgroup23_C_SO interestgroup24_C_SO interestgroup25_C_SO interestgroup26_C_SO interestgroup27_C_SO interestgroup28_C_SO interestgroup29_C_SO interestgroup30_C_SO interestgroup31_C_SO interestgroup32_C_SO interestgroup33_C_SO interestgroup34_C_SO interestgroup35_C_SO interestgroup36_C_SO interestgroup37_C_SO interestgroup38_C_SO interestgroup39_C_SO interestgroup40_C_SO interestgroup41_C_SO interestgroup42_C_SO interestgroup43_C_SO interestgroup44_C_SO interestgroup45_C_SO interestgroup46_C_SO interestgroup47_C_SO interestgroup48_C_SO interestgroup49_C_SO interestgroup50_C_SO interestgroup51_C_SO interestgroup52_C_SO interestgroup53_C_SO interestgroup54_C_SO interestgroup55_C_SO interestgroup56_C_SO interestgroup57_C_SO interestgroup58_C_SO interestgroup59_C_SO interestgroup60_C_SO interestgroup61_C_SO interestgroup62_C_SO interestgroup63_C_SO interestgroup64_C_SO interestgroup65_C_SO interestgroup66_C_SO interestgroup67_C_SO interestgroup68_C_SO interestgroup69_C_SO interestgroup70_C_SO interestgroup71_C_SO interestgroup72_C_SO interestgroup73_C_SO interestgroup74_C_SO interestgroup75_C_SO interestgroup76_C_SO interestgroup77_C_SO interestgroup78_C_SO interestgroup79_C_SO interestgroup80_C_SO interestgroup81_C_SO interestgroup82_C_SO interestgroup83_C_SO interestgroup84_C_SO interestgroup85_C_SO interestgroup86_C_SO interestgroup87_C_SO interestgroup88_C_SO interestgroup89_C_SO interestgroup90_C_SO interestgroup91_C_SO interestgroup92_C_SO interestgroup93_C_SO interestgroup94_C_SO interestgroup95_C_SO interestgroup96_C_SO interestgroup97_C_SO interestgroup98_C_SO interestgroup99_C_SO interestgroup100_C_SO interestgroup101_C_SO interestgroup102_C_SO interestgroup103_C_SO interestgroup104_C_SO interestgroup105_C_SO interestgroup106_C_SO interestgroup107_C_SO interestgroup108_C_SO interestgroup109_C_SO interestgroup110_C_SO interestgroup111_C_SO interestgroup112_C_SO interestgroup113_C_SO interestgroup114_C_SO interestgroup115_C_SO interestgroup116_C_SO interestgroup117_C_SO interestgroup118_C_SO interestgroup119_C_SO interestgroup120_C_SO interestgroup121_C_SO interestgroup122_C_SO interestgroup123_C_SO interestgroup124_C_SO interestgroup125_C_SO interestgroup126_C_SO interestgroup127_C_SO interestgroup128_C_SO interestgroup129_C_SO interestgroup130_C_SO interestgroup131_C_SO interestgroup132_C_SO interestgroup133_C_SO interestgroup134_C_SO interestgroup135_C_SO interestgroup136_C_SO interestgroup137_C_SO interestgroup138_C_SO interestgroup139_C_SO interestgroup140_C_SO interestgroup141_C_SO interestgroup142_C_SO interestgroup143_C_SO interestgroup144_C_SO interestgroup145_C_SO interestgroup146_C_SO interestgroup147_C_SO interestgroup148_C_SO interestgroup149_C_SO interestgroup150_C_SO interestgroup151_C_SO interestgroup152_C_SO interestgroup153_C_SO interestgroup154_C_SO interestgroup155_C_SO interestgroup156_C_SO interestgroup157_C_SO interestgroup158_C_SO interestgroup159_C_SO interestgroup160_C_SO interestgroup161_C_SO interestgroup162_C_SO interestgroup163_C_SO interestgroup164_C_SO interestgroup165_C_SO interestgroup166_C_SO interestgroup167_C_SO interestgroup168_C_SO interestgroup169_C_SO interestgroup170_C_SO interestgroup171_C_SO interestgroup172_C_SO interestgroup173_C_SO interestgroup174_C_SO interestgroup175_C_SO interestgroup176_C_SO interestgroup177_C_SO interestgroup178_C_SO interestgroup179_C_SO interestgroup180_C_SO)	/// 
	, values(1)
	
egen nonmiss_supp_LN_SO = anycount( /// 
	interestgroup1_LN_SO interestgroup2_LN_SO interestgroup3_LN_SO interestgroup4_LN_SO interestgroup5_LN_SO interestgroup6_LN_SO interestgroup7_LN_SO interestgroup8_LN_SO interestgroup9_LN_SO interestgroup10_LN_SO interestgroup11_LN_SO interestgroup12_LN_SO interestgroup13_LN_SO interestgroup14_LN_SO interestgroup15_LN_SO interestgroup16_LN_SO interestgroup17_LN_SO interestgroup18_LN_SO interestgroup19_LN_SO interestgroup20_LN_SO interestgroup21_LN_SO interestgroup22_LN_SO interestgroup23_LN_SO interestgroup24_LN_SO interestgroup25_LN_SO interestgroup26_LN_SO interestgroup27_LN_SO interestgroup28_LN_SO interestgroup29_LN_SO interestgroup30_LN_SO interestgroup31_LN_SO interestgroup32_LN_SO interestgroup33_LN_SO interestgroup34_LN_SO interestgroup35_LN_SO interestgroup36_LN_SO interestgroup37_LN_SO interestgroup38_LN_SO interestgroup39_LN_SO interestgroup40_LN_SO interestgroup41_LN_SO interestgroup42_LN_SO interestgroup43_LN_SO interestgroup44_LN_SO interestgroup45_LN_SO interestgroup46_LN_SO interestgroup47_LN_SO interestgroup48_LN_SO interestgroup49_LN_SO interestgroup50_LN_SO interestgroup51_LN_SO interestgroup52_LN_SO interestgroup53_LN_SO interestgroup54_LN_SO interestgroup55_LN_SO interestgroup56_LN_SO interestgroup57_LN_SO interestgroup58_LN_SO interestgroup59_LN_SO interestgroup60_LN_SO interestgroup61_LN_SO interestgroup62_LN_SO interestgroup63_LN_SO interestgroup64_LN_SO interestgroup65_LN_SO interestgroup66_LN_SO interestgroup67_LN_SO interestgroup68_LN_SO interestgroup69_LN_SO interestgroup70_LN_SO interestgroup71_LN_SO interestgroup72_LN_SO interestgroup73_LN_SO interestgroup74_LN_SO interestgroup75_LN_SO interestgroup76_LN_SO interestgroup77_LN_SO interestgroup78_LN_SO interestgroup79_LN_SO interestgroup80_LN_SO interestgroup81_LN_SO interestgroup82_LN_SO interestgroup83_LN_SO interestgroup84_LN_SO interestgroup85_LN_SO interestgroup86_LN_SO interestgroup87_LN_SO interestgroup88_LN_SO interestgroup89_LN_SO interestgroup90_LN_SO interestgroup91_LN_SO interestgroup92_LN_SO interestgroup93_LN_SO interestgroup94_LN_SO interestgroup95_LN_SO interestgroup96_LN_SO interestgroup97_LN_SO interestgroup98_LN_SO interestgroup99_LN_SO interestgroup100_LN_SO interestgroup101_LN_SO interestgroup102_LN_SO interestgroup103_LN_SO interestgroup104_LN_SO interestgroup105_LN_SO interestgroup106_LN_SO interestgroup107_LN_SO interestgroup108_LN_SO interestgroup109_LN_SO interestgroup110_LN_SO interestgroup111_LN_SO interestgroup112_LN_SO interestgroup113_LN_SO interestgroup114_LN_SO interestgroup115_LN_SO interestgroup116_LN_SO interestgroup117_LN_SO interestgroup118_LN_SO interestgroup119_LN_SO interestgroup120_LN_SO interestgroup121_LN_SO interestgroup122_LN_SO interestgroup123_LN_SO interestgroup124_LN_SO interestgroup125_LN_SO interestgroup126_LN_SO interestgroup127_LN_SO interestgroup128_LN_SO interestgroup129_LN_SO interestgroup130_LN_SO interestgroup131_LN_SO) ///
	, values(1)
	
egen nonmiss_opp_C_SO = anycount( /// 
	interestgroup1_C_SO interestgroup2_C_SO interestgroup3_C_SO interestgroup4_C_SO interestgroup5_C_SO interestgroup6_C_SO interestgroup7_C_SO interestgroup8_C_SO interestgroup9_C_SO interestgroup10_C_SO interestgroup11_C_SO interestgroup12_C_SO interestgroup13_C_SO interestgroup14_C_SO interestgroup15_C_SO interestgroup16_C_SO interestgroup17_C_SO interestgroup18_C_SO interestgroup19_C_SO interestgroup20_C_SO interestgroup21_C_SO interestgroup22_C_SO interestgroup23_C_SO interestgroup24_C_SO interestgroup25_C_SO interestgroup26_C_SO interestgroup27_C_SO interestgroup28_C_SO interestgroup29_C_SO interestgroup30_C_SO interestgroup31_C_SO interestgroup32_C_SO interestgroup33_C_SO interestgroup34_C_SO interestgroup35_C_SO interestgroup36_C_SO interestgroup37_C_SO interestgroup38_C_SO interestgroup39_C_SO interestgroup40_C_SO interestgroup41_C_SO interestgroup42_C_SO interestgroup43_C_SO interestgroup44_C_SO interestgroup45_C_SO interestgroup46_C_SO interestgroup47_C_SO interestgroup48_C_SO interestgroup49_C_SO interestgroup50_C_SO interestgroup51_C_SO interestgroup52_C_SO interestgroup53_C_SO interestgroup54_C_SO interestgroup55_C_SO interestgroup56_C_SO interestgroup57_C_SO interestgroup58_C_SO interestgroup59_C_SO interestgroup60_C_SO interestgroup61_C_SO interestgroup62_C_SO interestgroup63_C_SO interestgroup64_C_SO interestgroup65_C_SO interestgroup66_C_SO interestgroup67_C_SO interestgroup68_C_SO interestgroup69_C_SO interestgroup70_C_SO interestgroup71_C_SO interestgroup72_C_SO interestgroup73_C_SO interestgroup74_C_SO interestgroup75_C_SO interestgroup76_C_SO interestgroup77_C_SO interestgroup78_C_SO interestgroup79_C_SO interestgroup80_C_SO interestgroup81_C_SO interestgroup82_C_SO interestgroup83_C_SO interestgroup84_C_SO interestgroup85_C_SO interestgroup86_C_SO interestgroup87_C_SO interestgroup88_C_SO interestgroup89_C_SO interestgroup90_C_SO interestgroup91_C_SO interestgroup92_C_SO interestgroup93_C_SO interestgroup94_C_SO interestgroup95_C_SO interestgroup96_C_SO interestgroup97_C_SO interestgroup98_C_SO interestgroup99_C_SO interestgroup100_C_SO interestgroup101_C_SO interestgroup102_C_SO interestgroup103_C_SO interestgroup104_C_SO interestgroup105_C_SO interestgroup106_C_SO interestgroup107_C_SO interestgroup108_C_SO interestgroup109_C_SO interestgroup110_C_SO interestgroup111_C_SO interestgroup112_C_SO interestgroup113_C_SO interestgroup114_C_SO interestgroup115_C_SO interestgroup116_C_SO interestgroup117_C_SO interestgroup118_C_SO interestgroup119_C_SO interestgroup120_C_SO interestgroup121_C_SO interestgroup122_C_SO interestgroup123_C_SO interestgroup124_C_SO interestgroup125_C_SO interestgroup126_C_SO interestgroup127_C_SO interestgroup128_C_SO interestgroup129_C_SO interestgroup130_C_SO interestgroup131_C_SO interestgroup132_C_SO interestgroup133_C_SO interestgroup134_C_SO interestgroup135_C_SO interestgroup136_C_SO interestgroup137_C_SO interestgroup138_C_SO interestgroup139_C_SO interestgroup140_C_SO interestgroup141_C_SO interestgroup142_C_SO interestgroup143_C_SO interestgroup144_C_SO interestgroup145_C_SO interestgroup146_C_SO interestgroup147_C_SO interestgroup148_C_SO interestgroup149_C_SO interestgroup150_C_SO interestgroup151_C_SO interestgroup152_C_SO interestgroup153_C_SO interestgroup154_C_SO interestgroup155_C_SO interestgroup156_C_SO interestgroup157_C_SO interestgroup158_C_SO interestgroup159_C_SO interestgroup160_C_SO interestgroup161_C_SO interestgroup162_C_SO interestgroup163_C_SO interestgroup164_C_SO interestgroup165_C_SO interestgroup166_C_SO interestgroup167_C_SO interestgroup168_C_SO interestgroup169_C_SO interestgroup170_C_SO interestgroup171_C_SO interestgroup172_C_SO interestgroup173_C_SO interestgroup174_C_SO interestgroup175_C_SO interestgroup176_C_SO interestgroup177_C_SO interestgroup178_C_SO interestgroup179_C_SO interestgroup180_C_SO)	/// 
	, values(0)
	
egen nonmiss_opp_LN_SO = anycount( /// 
	interestgroup1_LN_SO interestgroup2_LN_SO interestgroup3_LN_SO interestgroup4_LN_SO interestgroup5_LN_SO interestgroup6_LN_SO interestgroup7_LN_SO interestgroup8_LN_SO interestgroup9_LN_SO interestgroup10_LN_SO interestgroup11_LN_SO interestgroup12_LN_SO interestgroup13_LN_SO interestgroup14_LN_SO interestgroup15_LN_SO interestgroup16_LN_SO interestgroup17_LN_SO interestgroup18_LN_SO interestgroup19_LN_SO interestgroup20_LN_SO interestgroup21_LN_SO interestgroup22_LN_SO interestgroup23_LN_SO interestgroup24_LN_SO interestgroup25_LN_SO interestgroup26_LN_SO interestgroup27_LN_SO interestgroup28_LN_SO interestgroup29_LN_SO interestgroup30_LN_SO interestgroup31_LN_SO interestgroup32_LN_SO interestgroup33_LN_SO interestgroup34_LN_SO interestgroup35_LN_SO interestgroup36_LN_SO interestgroup37_LN_SO interestgroup38_LN_SO interestgroup39_LN_SO interestgroup40_LN_SO interestgroup41_LN_SO interestgroup42_LN_SO interestgroup43_LN_SO interestgroup44_LN_SO interestgroup45_LN_SO interestgroup46_LN_SO interestgroup47_LN_SO interestgroup48_LN_SO interestgroup49_LN_SO interestgroup50_LN_SO interestgroup51_LN_SO interestgroup52_LN_SO interestgroup53_LN_SO interestgroup54_LN_SO interestgroup55_LN_SO interestgroup56_LN_SO interestgroup57_LN_SO interestgroup58_LN_SO interestgroup59_LN_SO interestgroup60_LN_SO interestgroup61_LN_SO interestgroup62_LN_SO interestgroup63_LN_SO interestgroup64_LN_SO interestgroup65_LN_SO interestgroup66_LN_SO interestgroup67_LN_SO interestgroup68_LN_SO interestgroup69_LN_SO interestgroup70_LN_SO interestgroup71_LN_SO interestgroup72_LN_SO interestgroup73_LN_SO interestgroup74_LN_SO interestgroup75_LN_SO interestgroup76_LN_SO interestgroup77_LN_SO interestgroup78_LN_SO interestgroup79_LN_SO interestgroup80_LN_SO interestgroup81_LN_SO interestgroup82_LN_SO interestgroup83_LN_SO interestgroup84_LN_SO interestgroup85_LN_SO interestgroup86_LN_SO interestgroup87_LN_SO interestgroup88_LN_SO interestgroup89_LN_SO interestgroup90_LN_SO interestgroup91_LN_SO interestgroup92_LN_SO interestgroup93_LN_SO interestgroup94_LN_SO interestgroup95_LN_SO interestgroup96_LN_SO interestgroup97_LN_SO interestgroup98_LN_SO interestgroup99_LN_SO interestgroup100_LN_SO interestgroup101_LN_SO interestgroup102_LN_SO interestgroup103_LN_SO interestgroup104_LN_SO interestgroup105_LN_SO interestgroup106_LN_SO interestgroup107_LN_SO interestgroup108_LN_SO interestgroup109_LN_SO interestgroup110_LN_SO interestgroup111_LN_SO interestgroup112_LN_SO interestgroup113_LN_SO interestgroup114_LN_SO interestgroup115_LN_SO interestgroup116_LN_SO interestgroup117_LN_SO interestgroup118_LN_SO interestgroup119_LN_SO interestgroup120_LN_SO interestgroup121_LN_SO interestgroup122_LN_SO interestgroup123_LN_SO interestgroup124_LN_SO interestgroup125_LN_SO interestgroup126_LN_SO interestgroup127_LN_SO interestgroup128_LN_SO interestgroup129_LN_SO interestgroup130_LN_SO interestgroup131_LN_SO) ///
	, values(0)
 	
label var nonmiss_supp_C_SO "nominees w c ig in support"	
label var nonmiss_opp_C_SO "nominees w c ig in opp"	
	
label var nonmiss_supp_LN_SO "nominees w ln ig in support"	
label var nonmiss_opp_LN_SO "nominees w ln ig in opp"	
	

* w/in database 
egen nonmiss_both_DB = rownonmiss( /// 
	interestgroup1_C_DB interestgroup2_C_DB interestgroup3_C_DB interestgroup4_C_DB interestgroup5_C_DB interestgroup6_C_DB interestgroup7_C_DB interestgroup8_C_DB interestgroup9_C_DB interestgroup10_C_DB interestgroup11_C_DB interestgroup12_C_DB interestgroup13_C_DB interestgroup14_C_DB interestgroup15_C_DB interestgroup16_C_DB interestgroup17_C_DB interestgroup18_C_DB interestgroup19_C_DB interestgroup20_C_DB interestgroup21_C_DB interestgroup22_C_DB interestgroup23_C_DB interestgroup24_C_DB interestgroup25_C_DB interestgroup26_C_DB interestgroup27_C_DB interestgroup28_C_DB interestgroup29_C_DB interestgroup30_C_DB interestgroup31_C_DB interestgroup32_C_DB interestgroup33_C_DB interestgroup34_C_DB interestgroup35_C_DB interestgroup36_C_DB interestgroup37_C_DB interestgroup38_C_DB interestgroup39_C_DB interestgroup40_C_DB interestgroup41_C_DB interestgroup42_C_DB interestgroup43_C_DB interestgroup44_C_DB interestgroup45_C_DB interestgroup46_C_DB interestgroup47_C_DB interestgroup48_C_DB interestgroup49_C_DB interestgroup50_C_DB interestgroup51_C_DB interestgroup52_C_DB interestgroup53_C_DB interestgroup54_C_DB interestgroup55_C_DB interestgroup56_C_DB interestgroup57_C_DB interestgroup58_C_DB interestgroup59_C_DB interestgroup60_C_DB interestgroup61_C_DB interestgroup62_C_DB interestgroup63_C_DB interestgroup64_C_DB interestgroup65_C_DB interestgroup66_C_DB interestgroup67_C_DB interestgroup68_C_DB interestgroup69_C_DB interestgroup70_C_DB interestgroup71_C_DB interestgroup72_C_DB interestgroup73_C_DB interestgroup74_C_DB interestgroup75_C_DB interestgroup76_C_DB interestgroup77_C_DB interestgroup78_C_DB interestgroup79_C_DB interestgroup80_C_DB interestgroup81_C_DB interestgroup82_C_DB interestgroup83_C_DB interestgroup84_C_DB interestgroup85_C_DB interestgroup86_C_DB interestgroup87_C_DB interestgroup88_C_DB interestgroup89_C_DB interestgroup90_C_DB interestgroup91_C_DB interestgroup92_C_DB interestgroup93_C_DB interestgroup94_C_DB interestgroup95_C_DB interestgroup96_C_DB interestgroup97_C_DB interestgroup98_C_DB interestgroup99_C_DB interestgroup100_C_DB interestgroup101_C_DB interestgroup102_C_DB interestgroup103_C_DB interestgroup104_C_DB interestgroup105_C_DB interestgroup106_C_DB interestgroup107_C_DB interestgroup108_C_DB interestgroup109_C_DB interestgroup110_C_DB interestgroup111_C_DB interestgroup112_C_DB interestgroup113_C_DB interestgroup114_C_DB interestgroup115_C_DB interestgroup116_C_DB interestgroup117_C_DB interestgroup118_C_DB interestgroup119_C_DB interestgroup120_C_DB interestgroup121_C_DB interestgroup122_C_DB interestgroup123_C_DB interestgroup124_C_DB interestgroup125_C_DB interestgroup126_C_DB interestgroup127_C_DB interestgroup128_C_DB interestgroup129_C_DB interestgroup130_C_DB interestgroup131_C_DB interestgroup132_C_DB interestgroup133_C_DB interestgroup134_C_DB interestgroup135_C_DB interestgroup136_C_DB interestgroup137_C_DB interestgroup138_C_DB interestgroup139_C_DB interestgroup140_C_DB interestgroup141_C_DB interestgroup142_C_DB interestgroup143_C_DB interestgroup144_C_DB interestgroup145_C_DB interestgroup146_C_DB interestgroup147_C_DB interestgroup148_C_DB interestgroup149_C_DB interestgroup150_C_DB interestgroup151_C_DB interestgroup152_C_DB interestgroup153_C_DB interestgroup154_C_DB interestgroup155_C_DB interestgroup156_C_DB interestgroup157_C_DB interestgroup158_C_DB interestgroup159_C_DB interestgroup160_C_DB interestgroup161_C_DB interestgroup162_C_DB interestgroup163_C_DB interestgroup164_C_DB interestgroup165_C_DB interestgroup166_C_DB interestgroup167_C_DB interestgroup168_C_DB interestgroup169_C_DB interestgroup170_C_DB interestgroup171_C_DB interestgroup172_C_DB interestgroup173_C_DB interestgroup174_C_DB interestgroup175_C_DB interestgroup176_C_DB interestgroup177_C_DB interestgroup178_C_DB interestgroup179_C_DB interestgroup180_C_DB	///
	interestgroup1_LN_DB interestgroup2_LN_DB interestgroup3_LN_DB interestgroup4_LN_DB interestgroup5_LN_DB interestgroup6_LN_DB interestgroup7_LN_DB interestgroup8_LN_DB interestgroup9_LN_DB interestgroup10_LN_DB interestgroup11_LN_DB interestgroup12_LN_DB interestgroup13_LN_DB interestgroup14_LN_DB interestgroup15_LN_DB interestgroup16_LN_DB interestgroup17_LN_DB interestgroup18_LN_DB interestgroup19_LN_DB interestgroup20_LN_DB interestgroup21_LN_DB interestgroup22_LN_DB interestgroup23_LN_DB interestgroup24_LN_DB interestgroup25_LN_DB interestgroup26_LN_DB interestgroup27_LN_DB interestgroup28_LN_DB interestgroup29_LN_DB interestgroup30_LN_DB interestgroup31_LN_DB interestgroup32_LN_DB interestgroup33_LN_DB interestgroup34_LN_DB interestgroup35_LN_DB interestgroup36_LN_DB interestgroup37_LN_DB interestgroup38_LN_DB interestgroup39_LN_DB interestgroup40_LN_DB interestgroup41_LN_DB interestgroup42_LN_DB interestgroup43_LN_DB interestgroup44_LN_DB interestgroup45_LN_DB interestgroup46_LN_DB interestgroup47_LN_DB interestgroup48_LN_DB interestgroup49_LN_DB interestgroup50_LN_DB interestgroup51_LN_DB interestgroup52_LN_DB interestgroup53_LN_DB interestgroup54_LN_DB interestgroup55_LN_DB interestgroup56_LN_DB interestgroup57_LN_DB interestgroup58_LN_DB interestgroup59_LN_DB interestgroup60_LN_DB interestgroup61_LN_DB interestgroup62_LN_DB interestgroup63_LN_DB interestgroup64_LN_DB interestgroup65_LN_DB interestgroup66_LN_DB interestgroup67_LN_DB interestgroup68_LN_DB interestgroup69_LN_DB interestgroup70_LN_DB interestgroup71_LN_DB interestgroup72_LN_DB interestgroup73_LN_DB interestgroup74_LN_DB interestgroup75_LN_DB interestgroup76_LN_DB interestgroup77_LN_DB interestgroup78_LN_DB interestgroup79_LN_DB interestgroup80_LN_DB interestgroup81_LN_DB interestgroup82_LN_DB interestgroup83_LN_DB interestgroup84_LN_DB interestgroup85_LN_DB interestgroup86_LN_DB interestgroup87_LN_DB interestgroup88_LN_DB interestgroup89_LN_DB interestgroup90_LN_DB interestgroup91_LN_DB interestgroup92_LN_DB interestgroup93_LN_DB interestgroup94_LN_DB interestgroup95_LN_DB interestgroup96_LN_DB interestgroup97_LN_DB interestgroup98_LN_DB interestgroup99_LN_DB interestgroup100_LN_DB interestgroup101_LN_DB interestgroup102_LN_DB interestgroup103_LN_DB interestgroup104_LN_DB interestgroup105_LN_DB interestgroup106_LN_DB interestgroup107_LN_DB interestgroup108_LN_DB interestgroup109_LN_DB interestgroup110_LN_DB interestgroup111_LN_DB interestgroup112_LN_DB interestgroup113_LN_DB interestgroup114_LN_DB interestgroup115_LN_DB interestgroup116_LN_DB interestgroup117_LN_DB interestgroup118_LN_DB interestgroup119_LN_DB interestgroup120_LN_DB interestgroup121_LN_DB interestgroup122_LN_DB interestgroup123_LN_DB interestgroup124_LN_DB interestgroup125_LN_DB interestgroup126_LN_DB interestgroup127_LN_DB interestgroup128_LN_DB interestgroup129_LN_DB interestgroup130_LN_DB interestgroup131_LN_DB ///
		) 

egen miss_both_DB = rowmiss( /// 
	interestgroup1_C_DB interestgroup2_C_DB interestgroup3_C_DB interestgroup4_C_DB interestgroup5_C_DB interestgroup6_C_DB interestgroup7_C_DB interestgroup8_C_DB interestgroup9_C_DB interestgroup10_C_DB interestgroup11_C_DB interestgroup12_C_DB interestgroup13_C_DB interestgroup14_C_DB interestgroup15_C_DB interestgroup16_C_DB interestgroup17_C_DB interestgroup18_C_DB interestgroup19_C_DB interestgroup20_C_DB interestgroup21_C_DB interestgroup22_C_DB interestgroup23_C_DB interestgroup24_C_DB interestgroup25_C_DB interestgroup26_C_DB interestgroup27_C_DB interestgroup28_C_DB interestgroup29_C_DB interestgroup30_C_DB interestgroup31_C_DB interestgroup32_C_DB interestgroup33_C_DB interestgroup34_C_DB interestgroup35_C_DB interestgroup36_C_DB interestgroup37_C_DB interestgroup38_C_DB interestgroup39_C_DB interestgroup40_C_DB interestgroup41_C_DB interestgroup42_C_DB interestgroup43_C_DB interestgroup44_C_DB interestgroup45_C_DB interestgroup46_C_DB interestgroup47_C_DB interestgroup48_C_DB interestgroup49_C_DB interestgroup50_C_DB interestgroup51_C_DB interestgroup52_C_DB interestgroup53_C_DB interestgroup54_C_DB interestgroup55_C_DB interestgroup56_C_DB interestgroup57_C_DB interestgroup58_C_DB interestgroup59_C_DB interestgroup60_C_DB interestgroup61_C_DB interestgroup62_C_DB interestgroup63_C_DB interestgroup64_C_DB interestgroup65_C_DB interestgroup66_C_DB interestgroup67_C_DB interestgroup68_C_DB interestgroup69_C_DB interestgroup70_C_DB interestgroup71_C_DB interestgroup72_C_DB interestgroup73_C_DB interestgroup74_C_DB interestgroup75_C_DB interestgroup76_C_DB interestgroup77_C_DB interestgroup78_C_DB interestgroup79_C_DB interestgroup80_C_DB interestgroup81_C_DB interestgroup82_C_DB interestgroup83_C_DB interestgroup84_C_DB interestgroup85_C_DB interestgroup86_C_DB interestgroup87_C_DB interestgroup88_C_DB interestgroup89_C_DB interestgroup90_C_DB interestgroup91_C_DB interestgroup92_C_DB interestgroup93_C_DB interestgroup94_C_DB interestgroup95_C_DB interestgroup96_C_DB interestgroup97_C_DB interestgroup98_C_DB interestgroup99_C_DB interestgroup100_C_DB interestgroup101_C_DB interestgroup102_C_DB interestgroup103_C_DB interestgroup104_C_DB interestgroup105_C_DB interestgroup106_C_DB interestgroup107_C_DB interestgroup108_C_DB interestgroup109_C_DB interestgroup110_C_DB interestgroup111_C_DB interestgroup112_C_DB interestgroup113_C_DB interestgroup114_C_DB interestgroup115_C_DB interestgroup116_C_DB interestgroup117_C_DB interestgroup118_C_DB interestgroup119_C_DB interestgroup120_C_DB interestgroup121_C_DB interestgroup122_C_DB interestgroup123_C_DB interestgroup124_C_DB interestgroup125_C_DB interestgroup126_C_DB interestgroup127_C_DB interestgroup128_C_DB interestgroup129_C_DB interestgroup130_C_DB interestgroup131_C_DB interestgroup132_C_DB interestgroup133_C_DB interestgroup134_C_DB interestgroup135_C_DB interestgroup136_C_DB interestgroup137_C_DB interestgroup138_C_DB interestgroup139_C_DB interestgroup140_C_DB interestgroup141_C_DB interestgroup142_C_DB interestgroup143_C_DB interestgroup144_C_DB interestgroup145_C_DB interestgroup146_C_DB interestgroup147_C_DB interestgroup148_C_DB interestgroup149_C_DB interestgroup150_C_DB interestgroup151_C_DB interestgroup152_C_DB interestgroup153_C_DB interestgroup154_C_DB interestgroup155_C_DB interestgroup156_C_DB interestgroup157_C_DB interestgroup158_C_DB interestgroup159_C_DB interestgroup160_C_DB interestgroup161_C_DB interestgroup162_C_DB interestgroup163_C_DB interestgroup164_C_DB interestgroup165_C_DB interestgroup166_C_DB interestgroup167_C_DB interestgroup168_C_DB interestgroup169_C_DB interestgroup170_C_DB interestgroup171_C_DB interestgroup172_C_DB interestgroup173_C_DB interestgroup174_C_DB interestgroup175_C_DB interestgroup176_C_DB interestgroup177_C_DB interestgroup178_C_DB interestgroup179_C_DB interestgroup180_C_DB	///
	interestgroup1_LN_DB interestgroup2_LN_DB interestgroup3_LN_DB interestgroup4_LN_DB interestgroup5_LN_DB interestgroup6_LN_DB interestgroup7_LN_DB interestgroup8_LN_DB interestgroup9_LN_DB interestgroup10_LN_DB interestgroup11_LN_DB interestgroup12_LN_DB interestgroup13_LN_DB interestgroup14_LN_DB interestgroup15_LN_DB interestgroup16_LN_DB interestgroup17_LN_DB interestgroup18_LN_DB interestgroup19_LN_DB interestgroup20_LN_DB interestgroup21_LN_DB interestgroup22_LN_DB interestgroup23_LN_DB interestgroup24_LN_DB interestgroup25_LN_DB interestgroup26_LN_DB interestgroup27_LN_DB interestgroup28_LN_DB interestgroup29_LN_DB interestgroup30_LN_DB interestgroup31_LN_DB interestgroup32_LN_DB interestgroup33_LN_DB interestgroup34_LN_DB interestgroup35_LN_DB interestgroup36_LN_DB interestgroup37_LN_DB interestgroup38_LN_DB interestgroup39_LN_DB interestgroup40_LN_DB interestgroup41_LN_DB interestgroup42_LN_DB interestgroup43_LN_DB interestgroup44_LN_DB interestgroup45_LN_DB interestgroup46_LN_DB interestgroup47_LN_DB interestgroup48_LN_DB interestgroup49_LN_DB interestgroup50_LN_DB interestgroup51_LN_DB interestgroup52_LN_DB interestgroup53_LN_DB interestgroup54_LN_DB interestgroup55_LN_DB interestgroup56_LN_DB interestgroup57_LN_DB interestgroup58_LN_DB interestgroup59_LN_DB interestgroup60_LN_DB interestgroup61_LN_DB interestgroup62_LN_DB interestgroup63_LN_DB interestgroup64_LN_DB interestgroup65_LN_DB interestgroup66_LN_DB interestgroup67_LN_DB interestgroup68_LN_DB interestgroup69_LN_DB interestgroup70_LN_DB interestgroup71_LN_DB interestgroup72_LN_DB interestgroup73_LN_DB interestgroup74_LN_DB interestgroup75_LN_DB interestgroup76_LN_DB interestgroup77_LN_DB interestgroup78_LN_DB interestgroup79_LN_DB interestgroup80_LN_DB interestgroup81_LN_DB interestgroup82_LN_DB interestgroup83_LN_DB interestgroup84_LN_DB interestgroup85_LN_DB interestgroup86_LN_DB interestgroup87_LN_DB interestgroup88_LN_DB interestgroup89_LN_DB interestgroup90_LN_DB interestgroup91_LN_DB interestgroup92_LN_DB interestgroup93_LN_DB interestgroup94_LN_DB interestgroup95_LN_DB interestgroup96_LN_DB interestgroup97_LN_DB interestgroup98_LN_DB interestgroup99_LN_DB interestgroup100_LN_DB interestgroup101_LN_DB interestgroup102_LN_DB interestgroup103_LN_DB interestgroup104_LN_DB interestgroup105_LN_DB interestgroup106_LN_DB interestgroup107_LN_DB interestgroup108_LN_DB interestgroup109_LN_DB interestgroup110_LN_DB interestgroup111_LN_DB interestgroup112_LN_DB interestgroup113_LN_DB interestgroup114_LN_DB interestgroup115_LN_DB interestgroup116_LN_DB interestgroup117_LN_DB interestgroup118_LN_DB interestgroup119_LN_DB interestgroup120_LN_DB interestgroup121_LN_DB interestgroup122_LN_DB interestgroup123_LN_DB interestgroup124_LN_DB interestgroup125_LN_DB interestgroup126_LN_DB interestgroup127_LN_DB interestgroup128_LN_DB interestgroup129_LN_DB interestgroup130_LN_DB interestgroup131_LN_DB ///
		)	

egen nonmiss_both_V1 = rownonmiss( /// 
    interestgroup1_C_V1 interestgroup2_C_V1 interestgroup3_C_V1 interestgroup4_C_V1 interestgroup5_C_V1 interestgroup6_C_V1 interestgroup7_C_V1 interestgroup8_C_V1 interestgroup9_C_V1 interestgroup10_C_V1 interestgroup11_C_V1 interestgroup12_C_V1 interestgroup13_C_V1 interestgroup14_C_V1 interestgroup15_C_V1 interestgroup16_C_V1 interestgroup17_C_V1 interestgroup18_C_V1 interestgroup19_C_V1 interestgroup20_C_V1 interestgroup21_C_V1 interestgroup22_C_V1 interestgroup23_C_V1 interestgroup24_C_V1 interestgroup25_C_V1 interestgroup26_C_V1 interestgroup27_C_V1 interestgroup28_C_V1 interestgroup29_C_V1 interestgroup30_C_V1 interestgroup31_C_V1 interestgroup32_C_V1 interestgroup33_C_V1 interestgroup34_C_V1 interestgroup35_C_V1 interestgroup36_C_V1 interestgroup37_C_V1 interestgroup38_C_V1 interestgroup39_C_V1 interestgroup40_C_V1 interestgroup41_C_V1 interestgroup42_C_V1 interestgroup43_C_V1 interestgroup44_C_V1 interestgroup45_C_V1 interestgroup46_C_V1 interestgroup47_C_V1 interestgroup48_C_V1 interestgroup49_C_V1 interestgroup50_C_V1 interestgroup51_C_V1 interestgroup52_C_V1 interestgroup53_C_V1 interestgroup54_C_V1 interestgroup55_C_V1 interestgroup56_C_V1 interestgroup57_C_V1 interestgroup58_C_V1 interestgroup59_C_V1 interestgroup60_C_V1 interestgroup61_C_V1 interestgroup62_C_V1 interestgroup63_C_V1 interestgroup64_C_V1 interestgroup65_C_V1 interestgroup66_C_V1 interestgroup67_C_V1 interestgroup68_C_V1 interestgroup69_C_V1 interestgroup70_C_V1 interestgroup71_C_V1 interestgroup72_C_V1 interestgroup73_C_V1 interestgroup74_C_V1 interestgroup75_C_V1 interestgroup76_C_V1 interestgroup77_C_V1 interestgroup78_C_V1 interestgroup79_C_V1 interestgroup80_C_V1 interestgroup81_C_V1 interestgroup82_C_V1 interestgroup83_C_V1 interestgroup84_C_V1 interestgroup85_C_V1 interestgroup86_C_V1 interestgroup87_C_V1 interestgroup88_C_V1 interestgroup89_C_V1 interestgroup90_C_V1 interestgroup91_C_V1 interestgroup92_C_V1 interestgroup93_C_V1 interestgroup94_C_V1 interestgroup95_C_V1 interestgroup96_C_V1 interestgroup97_C_V1 interestgroup98_C_V1 interestgroup99_C_V1 interestgroup100_C_V1 interestgroup101_C_V1 interestgroup102_C_V1 interestgroup103_C_V1 interestgroup104_C_V1 interestgroup105_C_V1 interestgroup106_C_V1 interestgroup107_C_V1 interestgroup108_C_V1 interestgroup109_C_V1 interestgroup110_C_V1 interestgroup111_C_V1 interestgroup112_C_V1 interestgroup113_C_V1 interestgroup114_C_V1 interestgroup115_C_V1 interestgroup116_C_V1 interestgroup117_C_V1 interestgroup118_C_V1 interestgroup119_C_V1 interestgroup120_C_V1 interestgroup121_C_V1 interestgroup122_C_V1 interestgroup123_C_V1 interestgroup124_C_V1 interestgroup125_C_V1 interestgroup126_C_V1 interestgroup127_C_V1 interestgroup128_C_V1 interestgroup129_C_V1 interestgroup130_C_V1 interestgroup131_C_V1 interestgroup132_C_V1 interestgroup133_C_V1 interestgroup134_C_V1 interestgroup135_C_V1 interestgroup136_C_V1 interestgroup137_C_V1 interestgroup138_C_V1 interestgroup139_C_V1 interestgroup140_C_V1 interestgroup141_C_V1 interestgroup142_C_V1 interestgroup143_C_V1 interestgroup144_C_V1 interestgroup145_C_V1 interestgroup146_C_V1 interestgroup147_C_V1 interestgroup148_C_V1 interestgroup149_C_V1 interestgroup150_C_V1 interestgroup151_C_V1 interestgroup152_C_V1 interestgroup153_C_V1 interestgroup154_C_V1 interestgroup155_C_V1 interestgroup156_C_V1 interestgroup157_C_V1 interestgroup158_C_V1 interestgroup159_C_V1 interestgroup160_C_V1 interestgroup161_C_V1 interestgroup162_C_V1 interestgroup163_C_V1 interestgroup164_C_V1 interestgroup165_C_V1 interestgroup166_C_V1 interestgroup167_C_V1 interestgroup168_C_V1 interestgroup169_C_V1 interestgroup170_C_V1 interestgroup171_C_V1 interestgroup172_C_V1 interestgroup173_C_V1 interestgroup174_C_V1 interestgroup175_C_V1 interestgroup176_C_V1 interestgroup177_C_V1 interestgroup178_C_V1 interestgroup179_C_V1 interestgroup180_C_V1	///
	interestgroup1_LN_V1 interestgroup2_LN_V1 interestgroup3_LN_V1 interestgroup4_LN_V1 interestgroup5_LN_V1 interestgroup6_LN_V1 interestgroup7_LN_V1 interestgroup8_LN_V1 interestgroup9_LN_V1 interestgroup10_LN_V1 interestgroup11_LN_V1 interestgroup12_LN_V1 interestgroup13_LN_V1 interestgroup14_LN_V1 interestgroup15_LN_V1 interestgroup16_LN_V1 interestgroup17_LN_V1 interestgroup18_LN_V1 interestgroup19_LN_V1 interestgroup20_LN_V1 interestgroup21_LN_V1 interestgroup22_LN_V1 interestgroup23_LN_V1 interestgroup24_LN_V1 interestgroup25_LN_V1 interestgroup26_LN_V1 interestgroup27_LN_V1 interestgroup28_LN_V1 interestgroup29_LN_V1 interestgroup30_LN_V1 interestgroup31_LN_V1 interestgroup32_LN_V1 interestgroup33_LN_V1 interestgroup34_LN_V1 interestgroup35_LN_V1 interestgroup36_LN_V1 interestgroup37_LN_V1 interestgroup38_LN_V1 interestgroup39_LN_V1 interestgroup40_LN_V1 interestgroup41_LN_V1 interestgroup42_LN_V1 interestgroup43_LN_V1 interestgroup44_LN_V1 interestgroup45_LN_V1 interestgroup46_LN_V1 interestgroup47_LN_V1 interestgroup48_LN_V1 interestgroup49_LN_V1 interestgroup50_LN_V1 interestgroup51_LN_V1 interestgroup52_LN_V1 interestgroup53_LN_V1 interestgroup54_LN_V1 interestgroup55_LN_V1 interestgroup56_LN_V1 interestgroup57_LN_V1 interestgroup58_LN_V1 interestgroup59_LN_V1 interestgroup60_LN_V1 interestgroup61_LN_V1 interestgroup62_LN_V1 interestgroup63_LN_V1 interestgroup64_LN_V1 interestgroup65_LN_V1 interestgroup66_LN_V1 interestgroup67_LN_V1 interestgroup68_LN_V1 interestgroup69_LN_V1 interestgroup70_LN_V1 interestgroup71_LN_V1 interestgroup72_LN_V1 interestgroup73_LN_V1 interestgroup74_LN_V1 interestgroup75_LN_V1 interestgroup76_LN_V1 interestgroup77_LN_V1 interestgroup78_LN_V1 interestgroup79_LN_V1 interestgroup80_LN_V1 interestgroup81_LN_V1 interestgroup82_LN_V1 interestgroup83_LN_V1 interestgroup84_LN_V1 interestgroup85_LN_V1 interestgroup86_LN_V1 interestgroup87_LN_V1 interestgroup88_LN_V1 interestgroup89_LN_V1 interestgroup90_LN_V1 interestgroup91_LN_V1 interestgroup92_LN_V1 interestgroup93_LN_V1 interestgroup94_LN_V1 interestgroup95_LN_V1 interestgroup96_LN_V1 interestgroup97_LN_V1 interestgroup98_LN_V1 interestgroup99_LN_V1 interestgroup100_LN_V1 interestgroup101_LN_V1 interestgroup102_LN_V1 interestgroup103_LN_V1 interestgroup104_LN_V1 interestgroup105_LN_V1 interestgroup106_LN_V1 interestgroup107_LN_V1 interestgroup108_LN_V1 interestgroup109_LN_V1 interestgroup110_LN_V1 interestgroup111_LN_V1 interestgroup112_LN_V1 interestgroup113_LN_V1 interestgroup114_LN_V1 interestgroup115_LN_V1 interestgroup116_LN_V1 interestgroup117_LN_V1 interestgroup118_LN_V1 interestgroup119_LN_V1 interestgroup120_LN_V1 interestgroup121_LN_V1 interestgroup122_LN_V1 interestgroup123_LN_V1 interestgroup124_LN_V1 interestgroup125_LN_V1 interestgroup126_LN_V1 interestgroup127_LN_V1 interestgroup128_LN_V1 interestgroup129_LN_V1 interestgroup130_LN_V1 interestgroup131_LN_V1 ///
		)  
	
egen nonmiss_both_V5 = rownonmiss( /// 
    interestgroup1_C_V5 interestgroup2_C_V5 interestgroup3_C_V5 interestgroup4_C_V5 interestgroup5_C_V5 interestgroup6_C_V5 interestgroup7_C_V5 interestgroup8_C_V5 interestgroup9_C_V5 interestgroup10_C_V5 interestgroup11_C_V5 interestgroup12_C_V5 interestgroup13_C_V5 interestgroup14_C_V5 interestgroup15_C_V5 interestgroup16_C_V5 interestgroup17_C_V5 interestgroup18_C_V5 interestgroup19_C_V5 interestgroup20_C_V5 interestgroup21_C_V5 interestgroup22_C_V5 interestgroup23_C_V5 interestgroup24_C_V5 interestgroup25_C_V5 interestgroup26_C_V5 interestgroup27_C_V5 interestgroup28_C_V5 interestgroup29_C_V5 interestgroup30_C_V5 interestgroup31_C_V5 interestgroup32_C_V5 interestgroup33_C_V5 interestgroup34_C_V5 interestgroup35_C_V5 interestgroup36_C_V5 interestgroup37_C_V5 interestgroup38_C_V5 interestgroup39_C_V5 interestgroup40_C_V5 interestgroup41_C_V5 interestgroup42_C_V5 interestgroup43_C_V5 interestgroup44_C_V5 interestgroup45_C_V5 interestgroup46_C_V5 interestgroup47_C_V5 interestgroup48_C_V5 interestgroup49_C_V5 interestgroup50_C_V5 interestgroup51_C_V5 interestgroup52_C_V5 interestgroup53_C_V5 interestgroup54_C_V5 interestgroup55_C_V5 interestgroup56_C_V5 interestgroup57_C_V5 interestgroup58_C_V5 interestgroup59_C_V5 interestgroup60_C_V5 interestgroup61_C_V5 interestgroup62_C_V5 interestgroup63_C_V5 interestgroup64_C_V5 interestgroup65_C_V5 interestgroup66_C_V5 interestgroup67_C_V5 interestgroup68_C_V5 interestgroup69_C_V5 interestgroup70_C_V5 interestgroup71_C_V5 interestgroup72_C_V5 interestgroup73_C_V5 interestgroup74_C_V5 interestgroup75_C_V5 interestgroup76_C_V5 interestgroup77_C_V5 interestgroup78_C_V5 interestgroup79_C_V5 interestgroup80_C_V5 interestgroup81_C_V5 interestgroup82_C_V5 interestgroup83_C_V5 interestgroup84_C_V5 interestgroup85_C_V5 interestgroup86_C_V5 interestgroup87_C_V5 interestgroup88_C_V5 interestgroup89_C_V5 interestgroup90_C_V5 interestgroup91_C_V5 interestgroup92_C_V5 interestgroup93_C_V5 interestgroup94_C_V5 interestgroup95_C_V5 interestgroup96_C_V5 interestgroup97_C_V5 interestgroup98_C_V5 interestgroup99_C_V5 interestgroup100_C_V5 interestgroup101_C_V5 interestgroup102_C_V5 interestgroup103_C_V5 interestgroup104_C_V5 interestgroup105_C_V5 interestgroup106_C_V5 interestgroup107_C_V5 interestgroup108_C_V5 interestgroup109_C_V5 interestgroup110_C_V5 interestgroup111_C_V5 interestgroup112_C_V5 interestgroup113_C_V5 interestgroup114_C_V5 interestgroup115_C_V5 interestgroup116_C_V5 interestgroup117_C_V5 interestgroup118_C_V5 interestgroup119_C_V5 interestgroup120_C_V5 interestgroup121_C_V5 interestgroup122_C_V5 interestgroup123_C_V5 interestgroup124_C_V5 interestgroup125_C_V5 interestgroup126_C_V5 interestgroup127_C_V5 interestgroup128_C_V5 interestgroup129_C_V5 interestgroup130_C_V5 interestgroup131_C_V5 interestgroup132_C_V5 interestgroup133_C_V5 interestgroup134_C_V5 interestgroup135_C_V5 interestgroup136_C_V5 interestgroup137_C_V5 interestgroup138_C_V5 interestgroup139_C_V5 interestgroup140_C_V5 interestgroup141_C_V5 interestgroup142_C_V5 interestgroup143_C_V5 interestgroup144_C_V5 interestgroup145_C_V5 interestgroup146_C_V5 interestgroup147_C_V5 interestgroup148_C_V5 interestgroup149_C_V5 interestgroup150_C_V5 interestgroup151_C_V5 interestgroup152_C_V5 interestgroup153_C_V5 interestgroup154_C_V5 interestgroup155_C_V5 interestgroup156_C_V5 interestgroup157_C_V5 interestgroup158_C_V5 interestgroup159_C_V5 interestgroup160_C_V5 interestgroup161_C_V5 interestgroup162_C_V5 interestgroup163_C_V5 interestgroup164_C_V5 interestgroup165_C_V5 interestgroup166_C_V5 interestgroup167_C_V5 interestgroup168_C_V5 interestgroup169_C_V5 interestgroup170_C_V5 interestgroup171_C_V5 interestgroup172_C_V5 interestgroup173_C_V5 interestgroup174_C_V5 interestgroup175_C_V5 interestgroup176_C_V5 interestgroup177_C_V5 interestgroup178_C_V5 interestgroup179_C_V5 interestgroup180_C_V5	///
	interestgroup1_LN_V5 interestgroup2_LN_V5 interestgroup3_LN_V5 interestgroup4_LN_V5 interestgroup5_LN_V5 interestgroup6_LN_V5 interestgroup7_LN_V5 interestgroup8_LN_V5 interestgroup9_LN_V5 interestgroup10_LN_V5 interestgroup11_LN_V5 interestgroup12_LN_V5 interestgroup13_LN_V5 interestgroup14_LN_V5 interestgroup15_LN_V5 interestgroup16_LN_V5 interestgroup17_LN_V5 interestgroup18_LN_V5 interestgroup19_LN_V5 interestgroup20_LN_V5 interestgroup21_LN_V5 interestgroup22_LN_V5 interestgroup23_LN_V5 interestgroup24_LN_V5 interestgroup25_LN_V5 interestgroup26_LN_V5 interestgroup27_LN_V5 interestgroup28_LN_V5 interestgroup29_LN_V5 interestgroup30_LN_V5 interestgroup31_LN_V5 interestgroup32_LN_V5 interestgroup33_LN_V5 interestgroup34_LN_V5 interestgroup35_LN_V5 interestgroup36_LN_V5 interestgroup37_LN_V5 interestgroup38_LN_V5 interestgroup39_LN_V5 interestgroup40_LN_V5 interestgroup41_LN_V5 interestgroup42_LN_V5 interestgroup43_LN_V5 interestgroup44_LN_V5 interestgroup45_LN_V5 interestgroup46_LN_V5 interestgroup47_LN_V5 interestgroup48_LN_V5 interestgroup49_LN_V5 interestgroup50_LN_V5 interestgroup51_LN_V5 interestgroup52_LN_V5 interestgroup53_LN_V5 interestgroup54_LN_V5 interestgroup55_LN_V5 interestgroup56_LN_V5 interestgroup57_LN_V5 interestgroup58_LN_V5 interestgroup59_LN_V5 interestgroup60_LN_V5 interestgroup61_LN_V5 interestgroup62_LN_V5 interestgroup63_LN_V5 interestgroup64_LN_V5 interestgroup65_LN_V5 interestgroup66_LN_V5 interestgroup67_LN_V5 interestgroup68_LN_V5 interestgroup69_LN_V5 interestgroup70_LN_V5 interestgroup71_LN_V5 interestgroup72_LN_V5 interestgroup73_LN_V5 interestgroup74_LN_V5 interestgroup75_LN_V5 interestgroup76_LN_V5 interestgroup77_LN_V5 interestgroup78_LN_V5 interestgroup79_LN_V5 interestgroup80_LN_V5 interestgroup81_LN_V5 interestgroup82_LN_V5 interestgroup83_LN_V5 interestgroup84_LN_V5 interestgroup85_LN_V5 interestgroup86_LN_V5 interestgroup87_LN_V5 interestgroup88_LN_V5 interestgroup89_LN_V5 interestgroup90_LN_V5 interestgroup91_LN_V5 interestgroup92_LN_V5 interestgroup93_LN_V5 interestgroup94_LN_V5 interestgroup95_LN_V5 interestgroup96_LN_V5 interestgroup97_LN_V5 interestgroup98_LN_V5 interestgroup99_LN_V5 interestgroup100_LN_V5 interestgroup101_LN_V5 interestgroup102_LN_V5 interestgroup103_LN_V5 interestgroup104_LN_V5 interestgroup105_LN_V5 interestgroup106_LN_V5 interestgroup107_LN_V5 interestgroup108_LN_V5 interestgroup109_LN_V5 interestgroup110_LN_V5 interestgroup111_LN_V5 interestgroup112_LN_V5 interestgroup113_LN_V5 interestgroup114_LN_V5 interestgroup115_LN_V5 interestgroup116_LN_V5 interestgroup117_LN_V5 interestgroup118_LN_V5 interestgroup119_LN_V5 interestgroup120_LN_V5 interestgroup121_LN_V5 interestgroup122_LN_V5 interestgroup123_LN_V5 interestgroup124_LN_V5 interestgroup125_LN_V5 interestgroup126_LN_V5 interestgroup127_LN_V5 interestgroup128_LN_V5 interestgroup129_LN_V5 interestgroup130_LN_V5 interestgroup131_LN_V5 ///
		)  

* support and opposition 

* gen v5 vars 
foreach var of varlist interestgroup1_C interestgroup2_C interestgroup3_C interestgroup4_C interestgroup5_C interestgroup6_C interestgroup7_C interestgroup8_C interestgroup9_C interestgroup10_C interestgroup11_C interestgroup12_C interestgroup13_C interestgroup14_C interestgroup15_C interestgroup16_C interestgroup17_C interestgroup18_C interestgroup19_C interestgroup20_C interestgroup21_C interestgroup22_C interestgroup23_C interestgroup24_C interestgroup25_C interestgroup26_C interestgroup27_C interestgroup28_C interestgroup29_C interestgroup30_C interestgroup31_C interestgroup32_C interestgroup33_C interestgroup34_C interestgroup35_C interestgroup36_C interestgroup37_C interestgroup38_C interestgroup39_C interestgroup40_C interestgroup41_C interestgroup42_C interestgroup43_C interestgroup44_C interestgroup45_C interestgroup46_C interestgroup47_C interestgroup48_C interestgroup49_C interestgroup50_C interestgroup51_C interestgroup52_C interestgroup53_C interestgroup54_C interestgroup55_C interestgroup56_C interestgroup57_C interestgroup58_C interestgroup59_C interestgroup60_C interestgroup61_C interestgroup62_C interestgroup63_C interestgroup64_C interestgroup65_C interestgroup66_C interestgroup67_C interestgroup68_C interestgroup69_C interestgroup70_C interestgroup71_C interestgroup72_C interestgroup73_C interestgroup74_C interestgroup75_C interestgroup76_C interestgroup77_C interestgroup78_C interestgroup79_C interestgroup80_C interestgroup81_C interestgroup82_C interestgroup83_C interestgroup84_C interestgroup85_C interestgroup86_C interestgroup87_C interestgroup88_C interestgroup89_C interestgroup90_C interestgroup91_C interestgroup92_C interestgroup93_C interestgroup94_C interestgroup95_C interestgroup96_C interestgroup97_C interestgroup98_C interestgroup99_C interestgroup100_C interestgroup101_C interestgroup102_C interestgroup103_C interestgroup104_C interestgroup105_C interestgroup106_C interestgroup107_C interestgroup108_C interestgroup109_C interestgroup110_C interestgroup111_C interestgroup112_C interestgroup113_C interestgroup114_C interestgroup115_C interestgroup116_C interestgroup117_C interestgroup118_C interestgroup119_C interestgroup120_C interestgroup121_C interestgroup122_C interestgroup123_C interestgroup124_C interestgroup125_C interestgroup126_C interestgroup127_C interestgroup128_C interestgroup129_C interestgroup130_C interestgroup131_C interestgroup132_C interestgroup133_C interestgroup134_C interestgroup135_C interestgroup136_C interestgroup137_C interestgroup138_C interestgroup139_C interestgroup140_C interestgroup141_C interestgroup142_C interestgroup143_C interestgroup144_C interestgroup145_C interestgroup146_C interestgroup147_C interestgroup148_C interestgroup149_C interestgroup150_C interestgroup151_C interestgroup152_C interestgroup153_C interestgroup154_C interestgroup155_C interestgroup156_C interestgroup157_C interestgroup158_C interestgroup159_C interestgroup160_C interestgroup161_C interestgroup162_C interestgroup163_C interestgroup164_C interestgroup165_C interestgroup166_C interestgroup167_C interestgroup168_C interestgroup169_C interestgroup170_C interestgroup171_C interestgroup172_C interestgroup173_C interestgroup174_C interestgroup175_C interestgroup176_C interestgroup177_C interestgroup178_C interestgroup179_C interestgroup180_C   interestgroup1_LN interestgroup2_LN interestgroup3_LN interestgroup4_LN interestgroup5_LN interestgroup6_LN interestgroup7_LN interestgroup8_LN interestgroup9_LN interestgroup10_LN interestgroup11_LN interestgroup12_LN interestgroup13_LN interestgroup14_LN interestgroup15_LN interestgroup16_LN interestgroup17_LN interestgroup18_LN interestgroup19_LN interestgroup20_LN interestgroup21_LN interestgroup22_LN interestgroup23_LN interestgroup24_LN interestgroup25_LN interestgroup26_LN interestgroup27_LN interestgroup28_LN interestgroup29_LN interestgroup30_LN interestgroup31_LN interestgroup32_LN interestgroup33_LN interestgroup34_LN interestgroup35_LN interestgroup36_LN interestgroup37_LN interestgroup38_LN interestgroup39_LN interestgroup40_LN interestgroup41_LN interestgroup42_LN interestgroup43_LN interestgroup44_LN interestgroup45_LN interestgroup46_LN interestgroup47_LN interestgroup48_LN interestgroup49_LN interestgroup50_LN interestgroup51_LN interestgroup52_LN interestgroup53_LN interestgroup54_LN interestgroup55_LN interestgroup56_LN interestgroup57_LN interestgroup58_LN interestgroup59_LN interestgroup60_LN interestgroup61_LN interestgroup62_LN interestgroup63_LN interestgroup64_LN interestgroup65_LN interestgroup66_LN interestgroup67_LN interestgroup68_LN interestgroup69_LN interestgroup70_LN interestgroup71_LN interestgroup72_LN interestgroup73_LN interestgroup74_LN interestgroup75_LN interestgroup76_LN interestgroup77_LN interestgroup78_LN interestgroup79_LN interestgroup80_LN interestgroup81_LN interestgroup82_LN interestgroup83_LN interestgroup84_LN interestgroup85_LN interestgroup86_LN interestgroup87_LN interestgroup88_LN interestgroup89_LN interestgroup90_LN interestgroup91_LN interestgroup92_LN interestgroup93_LN interestgroup94_LN interestgroup95_LN interestgroup96_LN interestgroup97_LN interestgroup98_LN interestgroup99_LN interestgroup100_LN interestgroup101_LN interestgroup102_LN interestgroup103_LN interestgroup104_LN interestgroup105_LN interestgroup106_LN interestgroup107_LN interestgroup108_LN interestgroup109_LN interestgroup110_LN interestgroup111_LN interestgroup112_LN interestgroup113_LN interestgroup114_LN interestgroup115_LN interestgroup116_LN interestgroup117_LN interestgroup118_LN interestgroup119_LN interestgroup120_LN interestgroup121_LN interestgroup122_LN interestgroup123_LN interestgroup124_LN interestgroup125_LN interestgroup126_LN interestgroup127_LN interestgroup128_LN interestgroup129_LN interestgroup130_LN interestgroup131_LN {
	gen `var'_V5_SO = `var'_SO
	}

* mvs on SO 0 v 1 
foreach var of varlist interestgroup1_C_V5 interestgroup2_C_V5 interestgroup3_C_V5 interestgroup4_C_V5 interestgroup5_C_V5 interestgroup6_C_V5 interestgroup7_C_V5 interestgroup8_C_V5 interestgroup9_C_V5 interestgroup10_C_V5 interestgroup11_C_V5 interestgroup12_C_V5 interestgroup13_C_V5 interestgroup14_C_V5 interestgroup15_C_V5 interestgroup16_C_V5 interestgroup17_C_V5 interestgroup18_C_V5 interestgroup19_C_V5 interestgroup20_C_V5 interestgroup21_C_V5 interestgroup22_C_V5 interestgroup23_C_V5 interestgroup24_C_V5 interestgroup25_C_V5 interestgroup26_C_V5 interestgroup27_C_V5 interestgroup28_C_V5 interestgroup29_C_V5 interestgroup30_C_V5 interestgroup31_C_V5 interestgroup32_C_V5 interestgroup33_C_V5 interestgroup34_C_V5 interestgroup35_C_V5 interestgroup36_C_V5 interestgroup37_C_V5 interestgroup38_C_V5 interestgroup39_C_V5 interestgroup40_C_V5 interestgroup41_C_V5 interestgroup42_C_V5 interestgroup43_C_V5 interestgroup44_C_V5 interestgroup45_C_V5 interestgroup46_C_V5 interestgroup47_C_V5 interestgroup48_C_V5 interestgroup49_C_V5 interestgroup50_C_V5 interestgroup51_C_V5 interestgroup52_C_V5 interestgroup53_C_V5 interestgroup54_C_V5 interestgroup55_C_V5 interestgroup56_C_V5 interestgroup57_C_V5 interestgroup58_C_V5 interestgroup59_C_V5 interestgroup60_C_V5 interestgroup61_C_V5 interestgroup62_C_V5 interestgroup63_C_V5 interestgroup64_C_V5 interestgroup65_C_V5 interestgroup66_C_V5 interestgroup67_C_V5 interestgroup68_C_V5 interestgroup69_C_V5 interestgroup70_C_V5 interestgroup71_C_V5 interestgroup72_C_V5 interestgroup73_C_V5 interestgroup74_C_V5 interestgroup75_C_V5 interestgroup76_C_V5 interestgroup77_C_V5 interestgroup78_C_V5 interestgroup79_C_V5 interestgroup80_C_V5 interestgroup81_C_V5 interestgroup82_C_V5 interestgroup83_C_V5 interestgroup84_C_V5 interestgroup85_C_V5 interestgroup86_C_V5 interestgroup87_C_V5 interestgroup88_C_V5 interestgroup89_C_V5 interestgroup90_C_V5 interestgroup91_C_V5 interestgroup92_C_V5 interestgroup93_C_V5 interestgroup94_C_V5 interestgroup95_C_V5 interestgroup96_C_V5 interestgroup97_C_V5 interestgroup98_C_V5 interestgroup99_C_V5 interestgroup100_C_V5 interestgroup101_C_V5 interestgroup102_C_V5 interestgroup103_C_V5 interestgroup104_C_V5 interestgroup105_C_V5 interestgroup106_C_V5 interestgroup107_C_V5 interestgroup108_C_V5 interestgroup109_C_V5 interestgroup110_C_V5 interestgroup111_C_V5 interestgroup112_C_V5 interestgroup113_C_V5 interestgroup114_C_V5 interestgroup115_C_V5 interestgroup116_C_V5 interestgroup117_C_V5 interestgroup118_C_V5 interestgroup119_C_V5 interestgroup120_C_V5 interestgroup121_C_V5 interestgroup122_C_V5 interestgroup123_C_V5 interestgroup124_C_V5 interestgroup125_C_V5 interestgroup126_C_V5 interestgroup127_C_V5 interestgroup128_C_V5 interestgroup129_C_V5 interestgroup130_C_V5 interestgroup131_C_V5 interestgroup132_C_V5 interestgroup133_C_V5 interestgroup134_C_V5 interestgroup135_C_V5 interestgroup136_C_V5 interestgroup137_C_V5 interestgroup138_C_V5 interestgroup139_C_V5 interestgroup140_C_V5 interestgroup141_C_V5 interestgroup142_C_V5 interestgroup143_C_V5 interestgroup144_C_V5 interestgroup145_C_V5 interestgroup146_C_V5 interestgroup147_C_V5 interestgroup148_C_V5 interestgroup149_C_V5 interestgroup150_C_V5 interestgroup151_C_V5 interestgroup152_C_V5 interestgroup153_C_V5 interestgroup154_C_V5 interestgroup155_C_V5 interestgroup156_C_V5 interestgroup157_C_V5 interestgroup158_C_V5 interestgroup159_C_V5 interestgroup160_C_V5 interestgroup161_C_V5 interestgroup162_C_V5 interestgroup163_C_V5 interestgroup164_C_V5 interestgroup165_C_V5 interestgroup166_C_V5 interestgroup167_C_V5 interestgroup168_C_V5 interestgroup169_C_V5 interestgroup170_C_V5 interestgroup171_C_V5 interestgroup172_C_V5 interestgroup173_C_V5 interestgroup174_C_V5 interestgroup175_C_V5 interestgroup176_C_V5 interestgroup177_C_V5 interestgroup178_C_V5 interestgroup179_C_V5 interestgroup180_C_V5 {
	   gen `var'_opp = `var'
	   replace `var'_opp = . if `var'_SO == 1
	   replace `var'_opp = . if `var'_SO == .	   
	   }		  
foreach var of varlist 	interestgroup1_LN_V5 interestgroup2_LN_V5 interestgroup3_LN_V5 interestgroup4_LN_V5 interestgroup5_LN_V5 interestgroup6_LN_V5 interestgroup7_LN_V5 interestgroup8_LN_V5 interestgroup9_LN_V5 interestgroup10_LN_V5 interestgroup11_LN_V5 interestgroup12_LN_V5 interestgroup13_LN_V5 interestgroup14_LN_V5 interestgroup15_LN_V5 interestgroup16_LN_V5 interestgroup17_LN_V5 interestgroup18_LN_V5 interestgroup19_LN_V5 interestgroup20_LN_V5 interestgroup21_LN_V5 interestgroup22_LN_V5 interestgroup23_LN_V5 interestgroup24_LN_V5 interestgroup25_LN_V5 interestgroup26_LN_V5 interestgroup27_LN_V5 interestgroup28_LN_V5 interestgroup29_LN_V5 interestgroup30_LN_V5 interestgroup31_LN_V5 interestgroup32_LN_V5 interestgroup33_LN_V5 interestgroup34_LN_V5 interestgroup35_LN_V5 interestgroup36_LN_V5 interestgroup37_LN_V5 interestgroup38_LN_V5 interestgroup39_LN_V5 interestgroup40_LN_V5 interestgroup41_LN_V5 interestgroup42_LN_V5 interestgroup43_LN_V5 interestgroup44_LN_V5 interestgroup45_LN_V5 interestgroup46_LN_V5 interestgroup47_LN_V5 interestgroup48_LN_V5 interestgroup49_LN_V5 interestgroup50_LN_V5 interestgroup51_LN_V5 interestgroup52_LN_V5 interestgroup53_LN_V5 interestgroup54_LN_V5 interestgroup55_LN_V5 interestgroup56_LN_V5 interestgroup57_LN_V5 interestgroup58_LN_V5 interestgroup59_LN_V5 interestgroup60_LN_V5 interestgroup61_LN_V5 interestgroup62_LN_V5 interestgroup63_LN_V5 interestgroup64_LN_V5 interestgroup65_LN_V5 interestgroup66_LN_V5 interestgroup67_LN_V5 interestgroup68_LN_V5 interestgroup69_LN_V5 interestgroup70_LN_V5 interestgroup71_LN_V5 interestgroup72_LN_V5 interestgroup73_LN_V5 interestgroup74_LN_V5 interestgroup75_LN_V5 interestgroup76_LN_V5 interestgroup77_LN_V5 interestgroup78_LN_V5 interestgroup79_LN_V5 interestgroup80_LN_V5 interestgroup81_LN_V5 interestgroup82_LN_V5 interestgroup83_LN_V5 interestgroup84_LN_V5 interestgroup85_LN_V5 interestgroup86_LN_V5 interestgroup87_LN_V5 interestgroup88_LN_V5 interestgroup89_LN_V5 interestgroup90_LN_V5 interestgroup91_LN_V5 interestgroup92_LN_V5 interestgroup93_LN_V5 interestgroup94_LN_V5 interestgroup95_LN_V5 interestgroup96_LN_V5 interestgroup97_LN_V5 interestgroup98_LN_V5 interestgroup99_LN_V5 interestgroup100_LN_V5 interestgroup101_LN_V5 interestgroup102_LN_V5 interestgroup103_LN_V5 interestgroup104_LN_V5 interestgroup105_LN_V5 interestgroup106_LN_V5 interestgroup107_LN_V5 interestgroup108_LN_V5 interestgroup109_LN_V5 interestgroup110_LN_V5 interestgroup111_LN_V5 interestgroup112_LN_V5 interestgroup113_LN_V5 interestgroup114_LN_V5 interestgroup115_LN_V5 interestgroup116_LN_V5 interestgroup117_LN_V5 interestgroup118_LN_V5 interestgroup119_LN_V5 interestgroup120_LN_V5 interestgroup121_LN_V5 interestgroup122_LN_V5 interestgroup123_LN_V5 interestgroup124_LN_V5 interestgroup125_LN_V5 interestgroup126_LN_V5 interestgroup127_LN_V5 interestgroup128_LN_V5 interestgroup129_LN_V5 interestgroup130_LN_V5 interestgroup131_LN_V5 {
	   gen `var'_opp = `var'
	   replace `var'_opp = . if `var'_SO == 1
	   replace `var'_opp = . if `var'_SO == . 
	   }
	   
egen nonmiss_opp_V5 = rownonmiss(interestgroup1_C_V5_opp-interestgroup131_LN_V5_opp)
label var nonmiss_opp_V5 "nominee w opp not missing ig evc"

foreach var of varlist interestgroup1_C_V5 interestgroup2_C_V5 interestgroup3_C_V5 interestgroup4_C_V5 interestgroup5_C_V5 interestgroup6_C_V5 interestgroup7_C_V5 interestgroup8_C_V5 interestgroup9_C_V5 interestgroup10_C_V5 interestgroup11_C_V5 interestgroup12_C_V5 interestgroup13_C_V5 interestgroup14_C_V5 interestgroup15_C_V5 interestgroup16_C_V5 interestgroup17_C_V5 interestgroup18_C_V5 interestgroup19_C_V5 interestgroup20_C_V5 interestgroup21_C_V5 interestgroup22_C_V5 interestgroup23_C_V5 interestgroup24_C_V5 interestgroup25_C_V5 interestgroup26_C_V5 interestgroup27_C_V5 interestgroup28_C_V5 interestgroup29_C_V5 interestgroup30_C_V5 interestgroup31_C_V5 interestgroup32_C_V5 interestgroup33_C_V5 interestgroup34_C_V5 interestgroup35_C_V5 interestgroup36_C_V5 interestgroup37_C_V5 interestgroup38_C_V5 interestgroup39_C_V5 interestgroup40_C_V5 interestgroup41_C_V5 interestgroup42_C_V5 interestgroup43_C_V5 interestgroup44_C_V5 interestgroup45_C_V5 interestgroup46_C_V5 interestgroup47_C_V5 interestgroup48_C_V5 interestgroup49_C_V5 interestgroup50_C_V5 interestgroup51_C_V5 interestgroup52_C_V5 interestgroup53_C_V5 interestgroup54_C_V5 interestgroup55_C_V5 interestgroup56_C_V5 interestgroup57_C_V5 interestgroup58_C_V5 interestgroup59_C_V5 interestgroup60_C_V5 interestgroup61_C_V5 interestgroup62_C_V5 interestgroup63_C_V5 interestgroup64_C_V5 interestgroup65_C_V5 interestgroup66_C_V5 interestgroup67_C_V5 interestgroup68_C_V5 interestgroup69_C_V5 interestgroup70_C_V5 interestgroup71_C_V5 interestgroup72_C_V5 interestgroup73_C_V5 interestgroup74_C_V5 interestgroup75_C_V5 interestgroup76_C_V5 interestgroup77_C_V5 interestgroup78_C_V5 interestgroup79_C_V5 interestgroup80_C_V5 interestgroup81_C_V5 interestgroup82_C_V5 interestgroup83_C_V5 interestgroup84_C_V5 interestgroup85_C_V5 interestgroup86_C_V5 interestgroup87_C_V5 interestgroup88_C_V5 interestgroup89_C_V5 interestgroup90_C_V5 interestgroup91_C_V5 interestgroup92_C_V5 interestgroup93_C_V5 interestgroup94_C_V5 interestgroup95_C_V5 interestgroup96_C_V5 interestgroup97_C_V5 interestgroup98_C_V5 interestgroup99_C_V5 interestgroup100_C_V5 interestgroup101_C_V5 interestgroup102_C_V5 interestgroup103_C_V5 interestgroup104_C_V5 interestgroup105_C_V5 interestgroup106_C_V5 interestgroup107_C_V5 interestgroup108_C_V5 interestgroup109_C_V5 interestgroup110_C_V5 interestgroup111_C_V5 interestgroup112_C_V5 interestgroup113_C_V5 interestgroup114_C_V5 interestgroup115_C_V5 interestgroup116_C_V5 interestgroup117_C_V5 interestgroup118_C_V5 interestgroup119_C_V5 interestgroup120_C_V5 interestgroup121_C_V5 interestgroup122_C_V5 interestgroup123_C_V5 interestgroup124_C_V5 interestgroup125_C_V5 interestgroup126_C_V5 interestgroup127_C_V5 interestgroup128_C_V5 interestgroup129_C_V5 interestgroup130_C_V5 interestgroup131_C_V5 interestgroup132_C_V5 interestgroup133_C_V5 interestgroup134_C_V5 interestgroup135_C_V5 interestgroup136_C_V5 interestgroup137_C_V5 interestgroup138_C_V5 interestgroup139_C_V5 interestgroup140_C_V5 interestgroup141_C_V5 interestgroup142_C_V5 interestgroup143_C_V5 interestgroup144_C_V5 interestgroup145_C_V5 interestgroup146_C_V5 interestgroup147_C_V5 interestgroup148_C_V5 interestgroup149_C_V5 interestgroup150_C_V5 interestgroup151_C_V5 interestgroup152_C_V5 interestgroup153_C_V5 interestgroup154_C_V5 interestgroup155_C_V5 interestgroup156_C_V5 interestgroup157_C_V5 interestgroup158_C_V5 interestgroup159_C_V5 interestgroup160_C_V5 interestgroup161_C_V5 interestgroup162_C_V5 interestgroup163_C_V5 interestgroup164_C_V5 interestgroup165_C_V5 interestgroup166_C_V5 interestgroup167_C_V5 interestgroup168_C_V5 interestgroup169_C_V5 interestgroup170_C_V5 interestgroup171_C_V5 interestgroup172_C_V5 interestgroup173_C_V5 interestgroup174_C_V5 interestgroup175_C_V5 interestgroup176_C_V5 interestgroup177_C_V5 interestgroup178_C_V5 interestgroup179_C_V5 interestgroup180_C_V5 {
	   gen `var'_supp = `var'
	   replace `var'_supp = . if `var'_SO == 0
	   replace `var'_supp = . if `var'_SO == .
	   }		  
foreach var of varlist 	interestgroup1_LN_V5 interestgroup2_LN_V5 interestgroup3_LN_V5 interestgroup4_LN_V5 interestgroup5_LN_V5 interestgroup6_LN_V5 interestgroup7_LN_V5 interestgroup8_LN_V5 interestgroup9_LN_V5 interestgroup10_LN_V5 interestgroup11_LN_V5 interestgroup12_LN_V5 interestgroup13_LN_V5 interestgroup14_LN_V5 interestgroup15_LN_V5 interestgroup16_LN_V5 interestgroup17_LN_V5 interestgroup18_LN_V5 interestgroup19_LN_V5 interestgroup20_LN_V5 interestgroup21_LN_V5 interestgroup22_LN_V5 interestgroup23_LN_V5 interestgroup24_LN_V5 interestgroup25_LN_V5 interestgroup26_LN_V5 interestgroup27_LN_V5 interestgroup28_LN_V5 interestgroup29_LN_V5 interestgroup30_LN_V5 interestgroup31_LN_V5 interestgroup32_LN_V5 interestgroup33_LN_V5 interestgroup34_LN_V5 interestgroup35_LN_V5 interestgroup36_LN_V5 interestgroup37_LN_V5 interestgroup38_LN_V5 interestgroup39_LN_V5 interestgroup40_LN_V5 interestgroup41_LN_V5 interestgroup42_LN_V5 interestgroup43_LN_V5 interestgroup44_LN_V5 interestgroup45_LN_V5 interestgroup46_LN_V5 interestgroup47_LN_V5 interestgroup48_LN_V5 interestgroup49_LN_V5 interestgroup50_LN_V5 interestgroup51_LN_V5 interestgroup52_LN_V5 interestgroup53_LN_V5 interestgroup54_LN_V5 interestgroup55_LN_V5 interestgroup56_LN_V5 interestgroup57_LN_V5 interestgroup58_LN_V5 interestgroup59_LN_V5 interestgroup60_LN_V5 interestgroup61_LN_V5 interestgroup62_LN_V5 interestgroup63_LN_V5 interestgroup64_LN_V5 interestgroup65_LN_V5 interestgroup66_LN_V5 interestgroup67_LN_V5 interestgroup68_LN_V5 interestgroup69_LN_V5 interestgroup70_LN_V5 interestgroup71_LN_V5 interestgroup72_LN_V5 interestgroup73_LN_V5 interestgroup74_LN_V5 interestgroup75_LN_V5 interestgroup76_LN_V5 interestgroup77_LN_V5 interestgroup78_LN_V5 interestgroup79_LN_V5 interestgroup80_LN_V5 interestgroup81_LN_V5 interestgroup82_LN_V5 interestgroup83_LN_V5 interestgroup84_LN_V5 interestgroup85_LN_V5 interestgroup86_LN_V5 interestgroup87_LN_V5 interestgroup88_LN_V5 interestgroup89_LN_V5 interestgroup90_LN_V5 interestgroup91_LN_V5 interestgroup92_LN_V5 interestgroup93_LN_V5 interestgroup94_LN_V5 interestgroup95_LN_V5 interestgroup96_LN_V5 interestgroup97_LN_V5 interestgroup98_LN_V5 interestgroup99_LN_V5 interestgroup100_LN_V5 interestgroup101_LN_V5 interestgroup102_LN_V5 interestgroup103_LN_V5 interestgroup104_LN_V5 interestgroup105_LN_V5 interestgroup106_LN_V5 interestgroup107_LN_V5 interestgroup108_LN_V5 interestgroup109_LN_V5 interestgroup110_LN_V5 interestgroup111_LN_V5 interestgroup112_LN_V5 interestgroup113_LN_V5 interestgroup114_LN_V5 interestgroup115_LN_V5 interestgroup116_LN_V5 interestgroup117_LN_V5 interestgroup118_LN_V5 interestgroup119_LN_V5 interestgroup120_LN_V5 interestgroup121_LN_V5 interestgroup122_LN_V5 interestgroup123_LN_V5 interestgroup124_LN_V5 interestgroup125_LN_V5 interestgroup126_LN_V5 interestgroup127_LN_V5 interestgroup128_LN_V5 interestgroup129_LN_V5 interestgroup130_LN_V5 interestgroup131_LN_V5 {
	   gen `var'_supp = `var'
	   replace `var'_supp = . if `var'_SO == 0
	   replace `var'_supp = . if `var'_SO == .
	   }

egen nonmiss_supp_V5 = rownonmiss(interestgroup1_C_V5_supp-interestgroup131_LN_V5_supp)
label var nonmiss_supp_V5 "nominee w supp not missing ig evc"

egen miss_supp_V5 = rowmiss(interestgroup1_C_V5_supp-interestgroup131_LN_V5_supp)
egen miss_opp_V5 = rowmiss(interestgroup1_C_V5_opp-interestgroup131_LN_V5_opp) 

label var miss_supp_V5 "nom # of missing ig evc in supp"
label var miss_opp_V5 "nom # of missing ig evc in opp"


* max 
egen max_supp_V5 = rowmax(interestgroup1_C_V5_supp-interestgroup131_LN_V5_supp)
egen max_opp_V5 = rowmax(interestgroup1_C_V5_opp-interestgroup131_LN_V5_opp)
	
label var max_supp_V5 "max ig evc in supp"
label var max_opp_V5 "max ig evc in opp"

egen max_supp_LN_V5 = rowmax(interestgroup1_LN_V5_supp-interestgroup131_LN_V5_supp)
egen max_supp_C_V5 = rowmax(interestgroup1_C_V5_supp-interestgroup180_C_V5_supp) 
egen max_opp_LN_V5 = rowmax(interestgroup1_LN_V5_opp-interestgroup131_LN_V5_opp)
egen max_opp_C_V5 = rowmax(interestgroup1_C_V5_opp-interestgroup180_C_V5_opp)

label var max_supp_LN_V5 "max ig LN evc in supp"
label var max_opp_LN_V5 "max ig LN evc in opp"	
label var max_supp_C_V5 "max ig C evc in supp"
label var max_opp_C_V5 "max ig C evc in opp"		
	
* max evc cutpoint
xtile max_supp_quart_V5 = max_supp_V5, nq(4)
xtile max_opp_quart_V5 = max_opp_V5, nq(4)

* top two quartiles qt34 
gen max_supp_qt34_V5 = 0
replace max_supp_qt34_V5 = 1 if max_supp_quart_V5 >= 3  
replace max_supp_qt34_V5 = . if max_supp_V5 == .  

gen max_opp_qt34_V5 = 0
replace max_opp_qt34_V5 = 1 if max_opp_quart_V5 >= 3 
replace max_opp_qt34_V5 = . if max_opp_V5 == .  

label var max_supp_qt34_V5 "max ig evc 3-4qt in supp"
label var max_opp_qt34_V5 "max ig evc 3-4qt in opp"

* for each LN and C 
xtile max_supp_LN_quart_V5 = max_supp_LN_V5, nq(4)
xtile max_opp_LN_quart_V5 = max_opp_LN_V5, nq(4)
xtile max_supp_C_quart_V5 = max_supp_C_V5, nq(4)
xtile max_opp_C_quart_V5 = max_opp_C_V5, nq(4)

* LN
gen max_supp_LN_qt34_V5 = 0
replace max_supp_LN_qt34_V5 = 1 if max_supp_LN_quart_V5 >= 3  
replace max_supp_LN_qt34_V5 = . if max_supp_LN_V5 == .  

gen max_opp_LN_qt34_V5 = 0
replace max_opp_LN_qt34_V5 = 1 if max_opp_LN_quart_V5 >= 3 
replace max_opp_LN_qt34_V5 = . if max_opp_LN_V5 == .  

label var max_supp_LN_qt34_V5 "max ig LN evc 3-4qt in supp"
label var max_opp_LN_qt34_V5 "max ig LN evc 3-4qt in opp"

* C
gen max_supp_C_qt34_V5 = 0
replace max_supp_C_qt34_V5 = 1 if max_supp_C_quart_V5 >= 3  
replace max_supp_C_qt34_V5 = . if max_supp_C_V5 == .  

gen max_opp_C_qt34_V5 = 0
replace max_opp_C_qt34_V5 = 1 if max_opp_C_quart_V5 >= 3 
replace max_opp_C_qt34_V5 = . if max_opp_C_V5 == .  

label var max_opp_C_qt34_V5 "max ig C evc 3-4qt in supp"
label var max_opp_C_qt34_V5 "max ig C evc 3-4qt in opp"

*maxes with 0s instead of nas 
tab max_supp_V5, mi 
gen max_supp_V5_na = max_supp_V5
replace max_supp_V5_na = 0 if max_supp_V5 == . 

tab max_opp_V5, mi 
gen max_opp_V5_na = max_opp_V5
replace max_opp_V5_na = 0 if max_opp_V5 == . 

label var max_supp_V5_na "max ig evc in supp else NAs=0"
label var max_opp_V5_na "max ig evc in opp else NAs=0"

* ln and c nas 
gen max_supp_LN_V5_na = max_supp_LN_V5
replace max_supp_LN_V5_na = 0 if max_supp_LN_V5 == . 
tab max_supp_LN_V5_na, mi 

gen max_opp_LN_V5_na = max_opp_LN_V5
replace max_opp_LN_V5_na = 0 if max_opp_LN_V5 == . 

label var max_supp_LN_V5_na "max ig LN evc in supp else NAs=0"
label var max_opp_LN_V5_na "max ig LN evc in opp else NAs=0"

gen max_supp_C_V5_na = max_supp_C_V5
replace max_supp_C_V5_na = 0 if max_supp_C_V5 == . 
tab max_supp_C_V5_na, mi 

gen max_opp_C_V5_na = max_opp_C_V5
replace max_opp_C_V5_na = 0 if max_opp_C_V5 == . 

label var max_supp_C_V5_na "max ig C evc in supp else NAs=0"
label var max_opp_C_V5_na "max ig C evc in opp else NAs=0"


* qt34 nas 
gen max_supp_qt34_V5_na = max_supp_qt34_V5
replace max_supp_qt34_V5_na = 0 if max_supp_qt34_V5 == . 

gen max_opp_qt34_V5_na = max_opp_qt34_V5
replace max_opp_qt34_V5_na = 0 if max_opp_qt34_V5 == . 

label var max_supp_qt34_V5_na "max ig qt3-4 evc in supp else NAs=0"
label var max_opp_qt34_V5_na "max ig qt3-4 evc in opp else NAs=0"


gen max_supp_LN_qt34_V5_na = max_supp_LN_qt34_V5
replace max_supp_LN_qt34_V5_na = 0 if max_supp_LN_qt34_V5 == . 

gen max_opp_LN_qt34_V5_na = max_opp_LN_qt34_V5
replace max_opp_LN_qt34_V5_na = 0 if max_opp_LN_qt34_V5 == . 

label var max_supp_LN_qt34_V5_na "max ig LN qt34 evc in supp else NAs=0"
label var max_opp_LN_qt34_V5_na "max ig LN qt34 evc in opp else NAs=0"

gen max_supp_C_qt34_V5_na = max_supp_C_qt34_V5
replace max_supp_C_qt34_V5_na = 0 if max_supp_C_qt34_V5 == . 

gen max_opp_C_qt34_V5_na = max_opp_C_qt34_V5
replace max_opp_C_qt34_V5_na = 0 if max_opp_C_qt34_V5 == . 

label var max_supp_C_qt34_V5_na "max ig C qt34 evc in supp else NAs=0"
label var max_opp_C_qt34_V5_na "max ig C qt34 evc in opp else NAs=0"

* nonmiss 
gen nonmiss_opp_SO_na = nonmiss_opp_SO
replace nonmiss_opp_SO_na = 0 if nonmiss_opp_SO == . 
label var nonmiss_opp_SO_na "count of ig in opposition for each nom"	

gen nonmiss_supp_SO_na = nonmiss_supp_SO
replace nonmiss_supp_SO_na = 0 if nonmiss_supp_SO == . 
label var nonmiss_supp_SO_na "count of ig in support for each nom"	

* dummy supported 
gen supp_dummy = 0
replace supp_dummy =1 if nonmiss_supp_SO >= 1 & nonmiss_supp_SO != .
label var supp_dummy "1 if nonmiss_supp_SO >= 1"

gen opp_dummy = 0
replace opp_dummy =1 if nonmiss_opp_SO >= 1 & nonmiss_opp_SO != . 
label var opp_dummy "1 if nonmiss_opp_SO >= 1"

* dummy evc supported 
gen supp_evc_dummy = 0
replace supp_evc_dummy =1 if max_supp_V5_na !=0
label var supp_evc_dummy "1 if max_supp_V5_na != 0"

gen opp_evc_dummy = 0
replace opp_evc_dummy =1 if max_opp_V5_na !=0
label var opp_evc_dummy "1 if max_opp_V5_na != 0"

* nas for the lnc 
gen nonmiss_opp_C_SO_na = nonmiss_opp_C_SO
replace nonmiss_opp_C_SO_na = 0 if nonmiss_opp_C_SO == . 
label var nonmiss_opp_C_SO_na "count of ig C in opposition for each nom"	

gen nonmiss_opp_LN_SO_na = nonmiss_opp_LN_SO
replace nonmiss_opp_LN_SO_na = 0 if nonmiss_opp_LN_SO == . 
label var nonmiss_opp_LN_SO_na "count of ig LN in opposition for each nom"	

gen nonmiss_supp_C_SO_na = nonmiss_supp_C_SO
replace nonmiss_supp_C_SO_na = 0 if nonmiss_supp_C_SO == . 
label var nonmiss_supp_C_SO_na "count of ig C in support for each nom"	

gen nonmiss_supp_LN_SO_na = nonmiss_supp_LN_SO
replace nonmiss_supp_LN_SO_na = 0 if nonmiss_supp_LN_SO == . 
label var nonmiss_supp_LN_SO_na "count of ig LN in support for each nom"	

* dummy out lnc 
gen max_supp_LN_V5_dum = max_supp_LN_V5_na
replace max_supp_LN_V5_dum = 1 if max_supp_LN_V5_na >= 1 
label var max_supp_LN_V5_dum "dummy of ig LN in support for each nom"

gen max_opp_LN_V5_dum = max_opp_LN_V5_na
replace max_opp_LN_V5_dum = 1 if max_opp_LN_V5_na >= 1 
label var max_opp_LN_V5_dum "dummy of ig LN in opposition for each nom"

gen max_supp_C_V5_dum = max_supp_C_V5_na
replace max_supp_C_V5_dum = 1 if max_supp_C_V5_na >= 1 
label var max_supp_C_V5_dum "dummy of ig C in support for each nom"

gen max_opp_C_V5_dum = max_opp_C_V5_na
replace max_opp_C_V5_dum = 1 if max_opp_C_V5_na >= 1 
label var max_opp_C_V5_dum "dummy of ig C in opposition for each nom"

* delete loop repeats 
drop interestgroup1_C_V5_SO-interestgroup131_LN_V5_SO	  

* standardize approval 
egen presapp_std = std(presapp)
label var presapp_std "pres approval standardized"

* std  ideols 
egen commmedideol_std = std(committeemedianideology)
label var commmedideol_std "committee median ideol standardized"  

egen committeechairideology_std = std(committeechairideology)  
gen comm_diff_std = committeechairideology_std - commmedideol_std

* homogeneity 
gen comm_homog_std = abs(comm_diff_std)
list committeechairideology_std commmedideol_std comm_diff_std comm_homog_std	
	
* congress dummies 	
gen C106 = 0
replace C106 = 1 if congress == 106 
gen C107 = 0
replace C107 = 1 if congress == 107 
gen C108 = 0
replace C108 = 1 if congress == 108 	
gen C109 = 0
replace C109 = 1 if congress == 109 
gen C110 = 0
replace C110 = 1 if congress == 110 
gen C111 = 0
replace C111 = 1 if congress == 111 
gen C112 = 0
replace C112 = 1 if congress == 112 
gen C113 = 0
replace C113 = 1 if congress == 113 
gen C114 = 0
replace C114 = 1 if congress == 114 
gen C115 = 0
replace C115 = 1 if congress == 115 

* tier dummies 
gen tier1 = 0 
replace tier1 = 1 if tier == 1
gen tier2 = 0 
replace tier2 = 1 if tier == 2
gen tier3 = 0 
replace tier3 = 1 if tier == 3

* date variables   
gen nomination = formalnominationdate1
tab nomination 
format nomination %d
label var nomination "dmy formatted nomination date"

tab dateofconfirmationvote1
gen confirmed = dateofconfirmationvote1
format confirmed %d
label var confirmed "dmy formatted confirmation date"

gen returnedwithdrawn = datereturnedwithdrawn1
format returnedwithdrawn %d
label var returnedwithdrawn "dmy formatted return or withdrawn date"

gen crwoutcomes = confirmed
replace crwoutcomes = returnedwithdrawn if confirmed == . 
format crwoutcomes %d
label var crwoutcomes "dmy formatted confirm return withdraw dates"

* full session time 
gen crwtime = crwoutcomes - nomination 
label var crwtime "days between crw & nomination"

* committee time 
gen commact = dateoflastcommitteeaction1 
replace commact = datereturnedwithdrawn1 if dateoflastcommitteeaction1 == . 
format commact %d 
label var commact "dmy formatted last committee action" 

gen commtime = commact - nomination 
label var commtime "days between last committee action & nomination"
replace commtime = 0 if commtime < 0 

* new committee time
gen commout = committeedatefinal 
replace commout = datereturnedwithdrawn1 if committeedatefinal == . 
format commout %d 
label var commout "dmy formatted out of committee" 

gen commouttime = commout - nomination 
label var commouttime "days between out of committee & nomination"
replace commouttime = 0 if commouttime < 0 
        
gen madeitout01=.
replace madeitout01=0 if committeeaction01==0
replace madeitout01=0 if committeeaction01==1 & confirmed01==0
replace madeitout01=0 if committeeaction01==2 & confirmed01==0
 
replace madeitout01=1 if committeeaction01==1 & confirmed01==1
replace madeitout01=1 if committeeaction01==2 & confirmed01==1
replace madeitout01=1 if committeeaction01==3 & confirmed01==1
replace madeitout01=1 if committeeaction01==3 & confirmed01==0
 
replace madeitout01=1 if nominationnumber=="PN1189" & congress==115
replace madeitout01=1 if nominationnumber=="PN102-110" & congress==110
replace madeitout01=1 if nominationnumber=="PN1679" & congress==115
replace madeitout01=1 if nominationnumber=="PN1625" & congress==114
replace madeitout01=1 if nominationnumber=="PN101-110" & congress==110
 
replace madeitout01=1 if nominationnumber=="PN912" & congress==114
replace madeitout01=1 if nominationnumber=="PN100-110" & congress==110
replace madeitout01=1 if nominationnumber=="PN1824-110" & congress==110
replace madeitout01=1 if nominationnumber=="PN653" & congress==112
replace madeitout01=1 if nominationnumber=="PN650" & congress==114
 
replace madeitout01=1 if nominationnumber=="PN817-107" & congress==107
replace madeitout01=1 if nominationnumber=="PN940" & congress==114
replace madeitout01=1 if nominationnumber=="PN814-107" & congress==107
replace madeitout01=1 if nominationnumber=="PN208" & congress==114
replace madeitout01=1 if nominationnumber=="PN1404-109" & congress==109
 
replace madeitout01=1 if nominationnumber=="PN955-106" & congress==106
replace madeitout01=1 if nominationnumber=="1456-111" & congress==111
replace madeitout01=1 if nominationnumber=="PN1194" & congress==114
replace madeitout01=1 if nominationnumber=="PN1561" & congress==114
replace madeitout01=1 if nominationnumber=="PN463" & congress==114
 
replace madeitout01=1 if nominationnumber=="PN51" & congress==114
replace madeitout01=1 if nominationnumber=="PN1094" & congress==113
replace madeitout01=0 if nominationnumber=="1834-111" & congress==111
replace madeitout01=0 if nominationnumber=="1639-111" & committeeaction01==3
replace madeitout01=0 if nominationnumber=="PN653" & congress==112 & committeeaction01==3
                      
* divided government 
tab congress
gen divgov=.

replace divgov=1 if congress==106
replace divgov=1 if congress==107
replace divgov=0 if congress==108
replace divgov=0 if congress==109
replace divgov=1 if congress==110
replace divgov=0 if congress==111
replace divgov=0 if congress==112
replace divgov=0 if congress==113
replace divgov=1 if congress==114
replace divgov=0 if congress==115
tab divgov
label var divgov "divided government dummy, all sessions (1=div gov)"

* pres support from voteview 
gen ideologyscore=.

* 106th Session * 
replace ideologyscore=55.15 if congress==106 & ANF==1
replace ideologyscore=36.3 if congress==106 & BHUA==1
replace ideologyscore=20.8 if congress==106 & COM==1
replace ideologyscore=38.15 if congress==106 & ENR==1
replace ideologyscore=23.65 if congress==106 & EPW==1
replace ideologyscore=55.15 if congress==106 & FIN==1
replace ideologyscore=67.1 if congress==106 & HELP==1
replace ideologyscore=49.6 if congress==106 & HSGA==1
replace ideologyscore=45.05 if congress==106 & IND==1
replace ideologyscore=42.0 if congress==106 & RA==1
replace ideologyscore=42.0 if congress==106 & SBUS==1
replace ideologyscore=63.4 if congress==106 & VET==1
tab ideologyscore

* 107th Session * 
replace ideologyscore=63.75 if congress==107 & ANF==1
replace ideologyscore=62.8 if congress==107 & BHUA==1
replace ideologyscore=66.5 if congress==107 & COM==1
replace ideologyscore=72.7 if congress==107 & ENR==1
replace ideologyscore=59.25 if congress==107 & EPW==1
replace ideologyscore=79.55 if congress==107 & FIN==1
replace ideologyscore=62.2 if congress==107 & HELP==1
replace ideologyscore=71.5 if congress==107 & HSGA==1
replace ideologyscore=64.95 if congress==107 & IND==1
replace ideologyscore=63.15 if congress==107 & RA==1
replace ideologyscore=64.65 if congress==107 & SBUS==1
replace ideologyscore=66.5 if congress==107 & VET==1

* 108th Session * 
replace ideologyscore=95.05 if congress==108 & ANF==1
replace ideologyscore=90.95 if congress==108 & BHUA==1
replace ideologyscore=91.75 if congress==108 & COM==1
replace ideologyscore=90.05 if congress==108 & ENR==1
replace ideologyscore=92.55 if congress==108 & EPW==1
replace ideologyscore=97.15 if congress==108 & FIN==1
replace ideologyscore=93.35 if congress==108 & HELP==1
replace ideologyscore=87.2 if congress==108 & HSGA==1
replace ideologyscore=83.95 if congress==108 & IND==1
replace ideologyscore=93.85 if congress==108 & RA==1
replace ideologyscore=82.2 if congress==108 & SBUS==1
replace ideologyscore=90.0 if congress==108 & VET==1

* 109th Session * 
replace ideologyscore=89.45 if congress==109 & ANF==1
replace ideologyscore=86.2 if congress==109 & BHUA==1
replace ideologyscore=88.0 if congress==109 & COM==1
replace ideologyscore=86.5 if congress==109 & ENR==1
replace ideologyscore=85.15 if congress==109 & EPW==1
replace ideologyscore=89.1 if congress==109 & FIN==1
replace ideologyscore=85.05 if congress==109 & HELP==1
replace ideologyscore=71.5 if congress==109 & HSGA==1
replace ideologyscore=70.15 if congress==109 & IND==1
replace ideologyscore=85.5 if congress==109 & RA==1
replace ideologyscore=67.9 if congress==109 & SBUS==1
replace ideologyscore=87.9 if congress==109 & VET==1
	
* 110th Session * 
replace ideologyscore=29.5 if congress==110 & ANF==1
replace ideologyscore=29.05 if congress==110 & BHUA==1
replace ideologyscore=38.35 if congress==110 & COM==1
replace ideologyscore=34.5 if congress==110 & ENR==1
replace ideologyscore=29.8 if congress==110 & EPW==1
replace ideologyscore=37.4 if congress==110 & FIN==1
replace ideologyscore=35.4 if congress==110 & HELP==1
replace ideologyscore=55.75 if congress==110 & HSGA==1
replace ideologyscore=33.85 if congress==110 & IND==1
replace ideologyscore=38.05 if congress==110 & RA==1
replace ideologyscore=34.35 if congress==110 & SBUS==1
replace ideologyscore=35.9 if congress==110 & VET==1
	
* 111th Session * 
replace ideologyscore=90.3 if congress==111 & ANF==1
replace ideologyscore=95.35 if congress==111 & BHUA==1
replace ideologyscore=86.2 if congress==111 & COM==1
replace ideologyscore=97.3 if congress==111 & ENR==1
replace ideologyscore=95.2 if congress==111 & EPW==1
replace ideologyscore=95.05 if congress==111 & FIN==1
replace ideologyscore=94.95 if congress==111 & HELP==1
replace ideologyscore=92.45 if congress==111 & HSGA==1
replace ideologyscore=92.45 if congress==111 & IND==1
replace ideologyscore=99.35 if congress==111 & RA==1
replace ideologyscore=92.2 if congress==111 & SBUS==1
replace ideologyscore=97.9 if congress==111 & VET==1
		
* 112th Session * 
replace ideologyscore=93.0 if congress==112 & ANF==1
replace ideologyscore=98.85 if congress==112 & BHUA==1
replace ideologyscore=87.65 if congress==112 & COM==1
replace ideologyscore=95.2 if congress==112 & ENR==1
replace ideologyscore=87.55 if congress==112 & EPW==1
replace ideologyscore=91.65 if congress==112 & FIN==1
replace ideologyscore=87.1 if congress==112 & HELP==1
replace ideologyscore=90.05 if congress==112 & HSGA==1
replace ideologyscore=93.55 if congress==112 & IND==1
replace ideologyscore=97.05 if congress==112 & RA==1
replace ideologyscore=88.6 if congress==112 & SBUS==1
replace ideologyscore=95.25 if congress==112 & VET==1
	
* 113th Session * 
replace ideologyscore=98.2 if congress==113 & ANF==1
replace ideologyscore=97.95 if congress==113 & BHUA==1
replace ideologyscore=84.9 if congress==113 & COM==1
replace ideologyscore=84.8 if congress==113 & ENR==1
replace ideologyscore=92.05 if congress==113 & EPW==1
replace ideologyscore=96.85 if congress==113 & FIN==1
replace ideologyscore=94.2 if congress==113 & HELP==1
replace ideologyscore=98.85 if congress==113 & HSGA==1
replace ideologyscore=95.5 if congress==113 & IND==1
replace ideologyscore=99.3 if congress==113 & RA==1
replace ideologyscore=98.55 if congress==113 & SBUS==1
replace ideologyscore=91.35 if congress==113 & VET==1
tab ideologyscore
label var ideologyscore "Pooles presidential support score (No 114-15)"

* create standardized version of the ideology score * 
egen ideologyscore_std = std(ideologyscore)
label var ideologyscore_std "pres support score standardized"
tab ideologyscore_std
	


*********************************************
* Appendix: 4 Summary Statistics & Sample Details

eststo: estpost summarize ///
	nonmiss_supp_SO_na nonmiss_opp_SO_na /// 
	max_supp_qt34_V5_na max_opp_qt34_V5_na /// 
	tier3 reappointment01 recess01 divgov ///  
    commmedideol_std committeechairideology_std ideologyscore_std presapp_std /// 
	ANF BHUA COM ENR EPW FIN HSGA IND RA SBUS VET TWO /// 	
	C106-C115  /// 
	returned01 withdrawn01 confirmed01 
esttab using "tables/summary_stats_table.tex", /// 
 cells("mean(fmt(3))  sd(fmt(3))  min(fmt(3))  max(fmt(3))  count(fmt(3))") a nodepvar /// 
 varlabels(nonmiss_supp_SO_na "Number Groups in Support" nonmiss_opp_SO_na "Number Groups in Opposition" ///
 max_supp_qt34_V5_na "Powerful Group in Support" max_opp_qt34_V5_na "Powerful Group in Opposition" ///
 tier3 "Third Tier" reappointment01 "Reappointment" recess01 "Recess Appointment" divgov "Divided Government" /// 
      commmedideol_std "Median Member Ideology" committeechairideology_std "Chair Ideology" ideologyscore_std "Presidential Support" presapp_std "Presidential Approval" ///
 ANF "Ag, Nutrition, Forestry" BHUA "Bank, Housing, Urban Affairs" COM "Commerce" ENR "Energy, Natural Resources" EPW "Environment, Public Works" FIN "Finance" HSGA "Home Security, Gov Affairs" IND "Indian Affairs" RA "Rules, Administration" SBUS "Small Business" VET "Veteran Affairs" ///
 TWO "Two Committees" C106 "106" C107 "107" C108 "108" C109 "109" C110 "110" C111 "111" C112 "112" C113 "113" C114 "114" C115 "115" /// 
 returned01 "Returned" withdrawn01 "Withdrawn" confirmed01 "Confirmed") ///    	
title(Summary Statistics of Variables table\label{summarystats})  
eststo clear 	
	
	
	
* save data 	
save "data_all_vars_jop2025.dta", replace 
clear 


****** EOF ******  
